On Wed, 20 Apr 2005, Tom Lane wrote:
> "Marc G. Fournier" <scrappy@postgresql.org> writes:
>> Is there a reason (other then it hasn't been implemented yet?) that the
>> following couldn't work?
>
>> SELECT id,count(id) AS cnt
>> FROM table
>> WHERE id IN ( 1,2,3,4,5)
>> GROUP BY id
>> HAVING cnt = 2;
>
> It's contrary to the SQL spec, for one thing ...
Of course it is *sigh*
Thanks ...
----
Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
Email: scrappy@hub.org Yahoo!: yscrappy ICQ: 7615664