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 or flat)
Thread:
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.

-Neil



In response to

Responses

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-2014 The PostgreSQL Global Development Group