| From: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Cc: | John Fabiani <johnf(at)jfcomputer(dot)com> |
| Subject: | Re: avoid the creating the type for setof |
| Date: | 2011-12-30 14:49:42 |
| Message-ID: | 201112300649.42983.adrian.klaver@gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
On Friday, December 30, 2011 6:26:19 am John Fabiani wrote:
> Hi,
> I recall somewhere I saw a simple plpgsql function that returned a table
> with more than one record that did not use a defined type or a temp table
> ( at least I think I did). Is it possible to create such a function that
> will return more than one record and not require a record type or temp
> table?
>
> something like
>
> return setof record as
> return query select ...
39.3.1. Declaring Function Parameters
Search for RETURNS TABLE
>
> return
>
>
> Johnf
--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John Fabiani | 2011-12-30 15:08:01 | Re: avoid the creating the type for setof |
| Previous Message | Thomas Kellerer | 2011-12-30 14:48:30 | Re: avoid the creating the type for setof |