Re: [GENERAL] Returning a RECORD, not SETOF RECORD

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Michael Fuhr <mike(at)fuhr(dot)org>
Cc: Thomas Hallgren <thhal(at)mailblocks(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: [GENERAL] Returning a RECORD, not SETOF RECORD
Date: 2005-04-29 17:34:49
Message-ID: 7209.1114796089@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Michael Fuhr <mike(at)fuhr(dot)org> writes:
> On Fri, Apr 29, 2005 at 10:36:05AM -0400, Tom Lane wrote:
>> regression=# select (xyz(unique1,unique2)).* from tenk1 limit 5;

> This is a little off topic, but I've noticed that the above invokes
> the function once per output column:

Yeah, that is unfortunate but doesn't seem very easy to fix.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message typing80wpm 2005-04-29 18:12:45 ip connection on local p2p network
Previous Message Mike Nolan 2005-04-29 17:32:26 Tuning queries inside a function

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2005-04-29 18:01:15 Re: performance of bitmap scans in nested loop joins
Previous Message Michael Fuhr 2005-04-29 17:21:35 Re: [GENERAL] Returning a RECORD, not SETOF RECORD