>
> > 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(at)candle(dot)pha(dot)pa(dot)us