Skip site navigation (1) Skip section navigation (2)

Re: subselects in the target list

From: Neil Conway <neilc(at)samurai(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: subselects in the target list
Date: 2005-02-03 05:02:52
Message-ID: 1107406972.26960.66.camel@localhost.localdomain (view raw, whole thread or download thread mbox)
Lists: 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.


In response to


pgsql-hackers by date

Next:From: Greg Sabino MullaneDate: 2005-02-03 05:16:24
Subject: Re: [NOVICE] Last ID Problem
Previous:From: Tom LaneDate: 2005-02-03 04:49:42
Subject: Re: pg_dump bug in 7.3.9 with sequences

Privacy Policy | About PostgreSQL
Copyright © 1996-2018 The PostgreSQL Global Development Group