Skip site navigation (1) Skip section navigation (2)

Re: [HACKERS] ERROR: pull_var_clause: Cannot handle node type 108

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: José Soares <jose(at)sferacarta(dot)com>
Cc: hackers <pgsql-hackers(at)postgreSQL(dot)org>
Subject: Re: [HACKERS] ERROR: pull_var_clause: Cannot handle node type 108
Date: 1999-08-23 14:21:24
Message-ID: 23255.935418084@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
=?iso-8859-1?Q?Jos=E9?= Soares <jose(at)sferacarta(dot)com> writes:
> What does it mean?
> prova=> select nome from prova group by nome having count(*) > 1;
> [ OK ]

> 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

I take it you are using 6.4, because 6.5 generates different failure
messages.  But it's not any less broken :-(.  The rewriter seems to have
a bunch of bugs associated with aggregate functions in HAVING clauses of
sub-selects.  Or maybe it's just several manifestations of the same bug.
I have notes about this problem but do not understand it well enough to
fix it.  Perhaps Jan has a clue about it...

			regards, tom lane

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 1999-08-23 14:23:51
Subject: Re: [HACKERS] Array-fields and many-to-many relations
Previous:From: José SoaresDate: 1999-08-23 14:02:38
Subject: Re: [HACKERS] RE: [SQL] datediff function

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group