Re: avoid the creating the type for setof

From: John Fabiani <johnf(at)jfcomputer(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Re: avoid the creating the type for setof
Date: 2011-12-30 15:08:01
Message-ID: 3242358.vcvgTIkFkN@linux-12
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Jan Bakuwel 2011-12-30 22:51:41 Re: Current transaction is aborted, commands ignored until end of transaction block
Previous Message Adrian Klaver 2011-12-30 14:49:42 Re: avoid the creating the type for setof