Horton

Re: [HACKERS] =ANY bug

Bruce Momjian <maillist@candle.pha.pa.us>

View thread
From: Bruce Momjian <maillist@candle.pha.pa.us>
To: sferac@bo.nettuno.it
Cc: pgsql-hackers@postgreSQL.org, vadim@sable.krasnoyarsk.su (Vadim B. Mikheev)
Date: 1998-12-13T04:21:43Z
Lists: 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, Pennsylvania 19026