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

Tom Lane ha scritto:

> José Soares <jose@sferacarta.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

This is my ver:

hygea=> select version();
version
-------------------------------------------------------------------
PostgreSQL 6.5.0 on i586-pc-linux-gnulibc1, compiled by gcc 2.7.2.1
(1 row)


> 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