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
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.
In response to
pgsql-hackers by date
|Next:||From: Greg Sabino Mullane||Date: 2005-02-03 05:16:24|
|Subject: Re: [NOVICE] Last ID Problem|
|Previous:||From: Tom Lane||Date: 2005-02-03 04:49:42|
|Subject: Re: pg_dump bug in 7.3.9 with sequences |