> 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