Horton

Re: [HACKERS] subquery syntax broken

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

View thread
From: Bruce Momjian <maillist@candle.pha.pa.us>
To: lockhart@alumni.caltech.edu (Thomas G. Lockhart)
Cc: vadim@sable.krasnoyarsk.su, hackers@postgresql.org
Date: 1998-02-02T18:29:33Z
Lists: pgsql-hackers 
> 
> > 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...
> 

Sometimes you have = (subselect) with one row, often with correlated
subqueries, but most often with aggregates.


-- 
Bruce Momjian
maillist@candle.pha.pa.us