Re: Example of function returning SETOF RECORD

Lists: pgsql-patches
From: David Fetter <david(at)fetter(dot)org>
To: PostgreSQL Patches <pgsql-patches(at)postgresql(dot)org>
Subject: Example of function returning SETOF RECORD
Date: 2004-10-22 04:26:39
Message-ID: 20041022042639.GA2366@fetter.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-patches

Folks,

Here's a patch that adds an example of using SETOF RECORD with the
needed grammar.

Cheers,
D
--
David Fetter david(at)fetter(dot)org http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778

Remember to vote!

Attachment Content-Type Size
setof_record.diff text/plain 13.3 KB
From: David Fetter <david(at)fetter(dot)org>
To: PostgreSQL Patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: Example of function returning SETOF RECORD
Date: 2004-10-22 04:29:44
Message-ID: 20041022042944.GB2366@fetter.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-patches

On Thu, Oct 21, 2004 at 09:26:39PM -0700, David Fetter wrote:
> Folks,
>
> Here's a patch that adds an example of using SETOF RECORD with the
> needed grammar.

Oops. Please ignore previous patch. Here's the right one.

Cheers,
D
--
David Fetter david(at)fetter(dot)org http://fetter.org/
phone: +1 510 893 6100 mobile: +1 415 235 3778

Remember to vote!

Attachment Content-Type Size
setof_record.diff text/plain 1.5 KB
From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: David Fetter <david(at)fetter(dot)org>
Cc: PostgreSQL Patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: Example of function returning SETOF RECORD
Date: 2004-10-23 05:12:02
Message-ID: 22439.1098508322@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-patches

David Fetter <david(at)fetter(dot)org> writes:
>> Here's a patch that adds an example of using SETOF RECORD with the
>> needed grammar.

I'm having a bit of a problem with this, because it is a plpgsql example
inserted into a section that is solely about SQL-language functions.
Can you adapt it to be an SQL function? Or put the example into the
plpgsql chapter?

regards, tom lane