Horton

RE: [HACKERS] HAVING bug

Taral <taral@mail.utexas.edu>

View thread
From: "Taral" <taral@mail.utexas.edu>
To: <sferac@bo.nettuno.it>
Cc: <pgsql-bugs@postgreSQL.org>, <pgsql-hackers@postgreSQL.org>
Date: 1998-10-19T17:10:44Z
Lists: 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