having bug report - Mailing list pgsql-hackers

From José Soares
Subject having bug report
Date
Msg-id 3767ACA4.768CD3C9@sferacarta.com
Whole thread Raw
Responses Re: [HACKERS] having bug report  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: [HACKERS] having bug report  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-hackers
* subqueries containing HAVING return incorrect results

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

select istat from comuni where istat in (
select istat from comuni group by istat having 1 < count(istat)
);
ERROR:  pull_var_clause: Cannot handle node type 108

______________________________________________________________
PostgreSQL 6.5.0 on i586-pc-linux-gnu, compiled by gcc 2.7.2.3
^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
Jose'




pgsql-hackers by date:

Previous
From: "Gene Sokolov"
Date:
Subject: Re: [HACKERS] 6.5.0 - Overflow bug in AVG( )
Next
From: José Soares
Date:
Subject: decimal & numeric report bug