Should the following work...? - Mailing list pgsql-hackers

From The Hermit Hacker
Subject Should the following work...?
Date
Msg-id Pine.BSF.4.05.9903301317110.55565-100000@thelab.hub.org
Whole thread Raw
List pgsql-hackers
select id  from clients where id = ( select id                from clients               where count(id) = 1 ) ;

The error I get is that you can't do the AGGREGATE int he WHERE clause,
but this is with a pre-v6.5 server too...technically, should the above be
possible?

Marc G. Fournier                   ICQ#7615664               IRC Nick: Scrappy
Systems Administrator @ hub.org 
primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org 



pgsql-hackers by date:

Previous
From: Thomas Lockhart
Date:
Subject: Re: [HACKERS] Regression failures
Next
From: Andrew Merrill
Date:
Subject: Re: [SQL] indexing a datetime by date