Re: [HACKERS] HAVING bug

> 
> PostgreSQL tells me, the following query is not valid, but I can't see
> nothing wrong.
> 
> prova=> select * from sp;
> sno  |pno  |qty
> -----+-----+---
> S1   |P1   |300
> S1   |P2   |200
> S1   |P3   |400
> S2   |P2   |400
> S3   |P2   |200
> S4   |P4   |300
> S4   |P5   |400
> (7 rows)
> 
> prova=>  select sno,qty  from sp  group by sno,qty having qty=300;
> ERROR:  This is not a valid having query!

HAVING is only to be used with aggregates.   In your case, qty is not an
aggregate.

At least, that is what I think is supposed to happen.

> 
> I tried the same query on Informix-SE and I have the following:
> 
> sno       qty
> 
> S1    300.000
> S4    300.000
> 
> I tried it also on Solid and I have the following:
> 
> SOLID SQL Editor (teletype) v.02.20.0007
> select sno,qty  from sp  group by sno,qty having qty = 300;
> SNO                          QTY
> ---                          ---
> S1                           300.
> S4                           300.
> 2 rows fetched.
> 
>             Jose'
> 
> 
> 
> 


-- 
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026