RE: [HACKERS] HAVING bug - Mailing list pgsql-hackers

> prova=>  select sno,qty  from sp  group by sno,qty having qty=300;
> ERROR:  This is not a valid having query!

Use WHERE for conditions like this.

SELECT sno, qty FROM sp WHERE qty=300 GROUP BY sno;

Taral