Re: [HACKERS] =ANY bug - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: [HACKERS] =ANY bug
Date
Msg-id 199812130421.XAA13936@candle.pha.pa.us
Whole thread Raw
In response to =ANY bug  (Sferacarta Software <sferac@bo.nettuno.it>)
List pgsql-hackers
> Hi all,
> 
> Because IN is semantically identical to =ANY
> here the same error using ANY:
> 
> select * from emp where ename =ANY (
>      select ename from emp group by ename having 1 < count(ename)
>      );

Can I just say that using HAVING inside a subquery is buggy?  Vadim, was
this already fixed?


--  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,
Pennsylvania19026
 


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] BUG ON HAVING CLAUSE
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] Sorry to nag, but... [Failures with arrays]