Re: avoid the creating the type for setof - Mailing list pgsql-sql

On Friday, December 30, 2011 06: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 ...
> 
> return
> 
> 
> Johnf

Thanks all - I knew I had seen it in the past.

Johnf