Re: returning Setof Record - Mailing list pgsql-novice

From Avi Schwartz
Subject Re: returning Setof Record
Date
Msg-id E61AFAFB-DC3F-11D7-AF96-000393AE5044@CFFtechnologies.com
Whole thread Raw
In response to returning Setof Record  (glenn <vmstech@tpg.com.au>)
List pgsql-novice
Glenn,

Try this for help.

http://techdocs.postgresql.org/guides/SetReturningFunctions

You will have to specify the structure of the record when you select
from the function.

Avi

On Monday, Sep 1, 2003, at 00:23 America/Chicago, glenn wrote:

> hi
> Q1 - is it at least notionally possible to declare a function to return
> 'setof record' - i.e. a generic composite type as opposed to a
> composite
> type based on an exisiting table?
>
> Q2 - Supposing it is possible When I try the above I get the error:
> "A column definition list is required for functions returning RECORD"
> So now I'm wondering how to define a "column defintition list" ?


pgsql-novice by date:

Previous
From: glenn
Date:
Subject: returning Setof Record
Next
From: Bruno Wolff III
Date:
Subject: Re: ORDER BY question