(fwd) [HACKERS] ERROR: pull_var_clause: Cannot handle node type 108

Andrey Gerzhov (kittle@freeland.alex-ua.com)
Sun, 29 Aug 1999 17:48:18 +0300 (EEST)

-- forwarded message --
Path: freeland.alex-ua.com!news.alexradio.kiev.ua!not-for-mail
Message-ID: <37C146A1.9DB058FE@sferacarta.com>
Date: Mon, 23 Aug 1999 15:03:29 +0200
From: =?iso-8859-1?Q?Jos=E9?= Soares <jose@sferacarta.com>
To: hackers <pgsql-hackers@postgreSQL.org>
Subject: [HACKERS] ERROR: pull_var_clause: Cannot handle node type 108
Newsgroups: alex.gated.pgsql.hackers
Lines: 23
Xref: freeland.alex-ua.com alex.gated.pgsql.hackers:10029

What does it mean?

prova=> select nome from prova group by nome having count(*) > 1;
nome
Carlos
Henrique
Jose
(3 rows)

prova=> select oid,* from prova where nome in (select nome from prova
group by nome having 1 < count(*));
ERROR: pull_var_clause: Cannot handle node type 108

prova=> select * from prova where nome in (select nome from prova group
by nome having count(*) > 1);
ERROR: rewrite: aggregate column of view must be at rigth side in qual

JosИ

************

-- end of forwarded message --

-- 
С тем, что не помешает никогда,
                                               Kittle