Re: [HACKERS] subquery syntax broken - Mailing list pgsql-hackers

From ocie@paracel.com
Subject Re: [HACKERS] subquery syntax broken
Date
Msg-id 9802021852.AA23763@dolomite.paracel.com
Whole thread Raw
In response to Re: [HACKERS] subquery syntax broken  ("Thomas G. Lockhart" <lockhart@alumni.caltech.edu>)
List 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

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] subquery syntax broken
Next
From: Shiby Thomas
Date:
Subject: compilation on sparc_solaris