Thread: Example of function returning SETOF RECORD

Example of function returning SETOF RECORD

From
David Fetter
Date:
Folks,

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

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

Remember to vote!

Attachment

Re: Example of function returning SETOF RECORD

From
David Fetter
Date:
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@fetter.org http://fetter.org/
phone: +1 510 893 6100   mobile: +1 415 235 3778

Remember to vote!

Attachment

Re: Example of function returning SETOF RECORD

From
Tom Lane
Date:
David Fetter <david@fetter.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