| From: | Avi Schwartz <avi(at)CFFtechnologies(dot)com> |
|---|---|
| To: | glenn <vmstech(at)tpg(dot)com(dot)au> |
| Cc: | "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org> |
| Subject: | Re: returning Setof Record |
| Date: | 2003-09-01 05:48:23 |
| Message-ID: | E61AFAFB-DC3F-11D7-AF96-000393AE5044@CFFtechnologies.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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" ?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruno Wolff III | 2003-09-01 07:04:36 | Re: ORDER BY question |
| Previous Message | glenn | 2003-09-01 05:23:51 | returning Setof Record |