Re: [HACKERS] subquery syntax broken

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: [HACKERS] subquery syntax broken
Дата
Msg-id 199802021829.NAA15514@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: [HACKERS] subquery syntax broken  ("Thomas G. Lockhart" <lockhart@alumni.caltech.edu>)
Список 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

В списке pgsql-hackers по дате отправления:

Предыдущее
От: "Thomas G. Lockhart"
Дата:
Сообщение: Re: [HACKERS] subquery syntax broken
Следующее
От: ocie@paracel.com
Дата:
Сообщение: Re: [HACKERS] subquery syntax broken