Example of function returning SETOF RECORD

Started by David Fetteralmost 22 years ago3 messagespatches
Jump to latest
#1David Fetter
david@fetter.org

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!

Attachments:

setof_record.difftext/plain; charset=us-asciiDownload+257-34
#2David Fetter
david@fetter.org
In reply to: David Fetter (#1)
Re: Example of function returning SETOF RECORD

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!

Attachments:

setof_record.difftext/plain; charset=us-asciiDownload+39-0
#3Tom Lane
tgl@sss.pgh.pa.us
In reply to: David Fetter (#2)
Re: Example of function returning SETOF RECORD

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