Horton

Re: [HACKERS] subquery syntax broken

ocie@paracel.com

View thread
From: ocie@paracel.com
To: lockhart@alumni.caltech.edu (Thomas G. Lockhart)
Cc: maillist@candle.pha.pa.us, vadim@sable.krasnoyarsk.su, hackers@postgreSQL.org
Date: 1998-02-02T18:52:10Z
Lists: pgsql-hackers 
Thomas G. Lockhart wrote:
> 
> > It's not the aggregates, it is the whole '= (subquery)' that is missing
> > from gram.y.  I am adding it now.
> 
> Right, and aggregates are the only way in general to get a singleton result from
> a subselect. OK, I forgot about "where y = (select 1)". Well, only _useful_
> way?? I'll bet I'm forgetting another one too...

How about "where y = (select distinct foo from bar where n=5)" ?

Ocie