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 ...
http://www.postgresql.org/docs/9.0/interactive/plpgsql-declarations.html#PLPGSQL-DECLARATION-PARAMETERS
39.3.1. Declaring Function Parameters
Search for RETURNS TABLE
>
> return
>
>
> Johnf
--
Adrian Klaver
adrian.klaver@gmail.com