Re: subselects in the target list

Поиск
Список
Период
Сортировка
От Neil Conway
Тема Re: subselects in the target list
Дата
Msg-id 1107406972.26960.66.camel@localhost.localdomain
обсуждение исходный текст
Ответ на Re: subselects in the target list  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: subselects in the target list
Список pgsql-hackers
On Wed, 2005-02-02 at 23:22 -0500, Tom Lane wrote:
> The syntax you are showing is designed
> to return a scalar.  It will (and should) barf on multiple rows as well
> as multiple columns.

I don't understand; the example I posted is of an SRF that returns
multiple rows of multiple columns, which is transformed into multiple
rows of a single column of composite type.

> I'm unconvinced that it's worth fixing
> considering that this whole behavior (SRFs in the targetlist) is
> deprecated.

It is? I think if we polished it somewhat, this is reasonably cool
functionality to have, and is consistent with the 8.0 work to make
composite types more widely usable.

-Neil




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