Re: return row from plpgsql? - Mailing list pgsql-general

From zhong ming wu
Subject Re: return row from plpgsql?
Date
Msg-id 9e434c4d1003170407p7d4d040cpc3da199d35bd3b67@mail.gmail.com
Whole thread Raw
In response to return row from plpgsql?  (zhong ming wu <mr.z.m.wu@gmail.com>)
List pgsql-general
On Wed, Mar 17, 2010 at 12:00 AM, Osvaldo Kussama
<osvaldo.kussama@gmail.com> wrote:
>
> For a RETURN SETOF function use:
>
> SELECT * FROM aplpgsqlfunction('%u');
>
> http://www.postgresql.org/docs/current/interactive/plpgsql-control-structures.html#PLPGSQL-STATEMENTS-RETURNING
>
> Osvaldo
>

I didn't know about RETURN SETOF.  I will look into it though it seems
just from that example that you have define a separate table just for
that function.

pgsql-general by date:

Previous
From: Pavel Stehule
Date:
Subject: Re: Avoiding SQL injection in Dynamic Queries (in plpgsql)
Next
From: Craig Ringer
Date:
Subject: Re: stopping processes, preventing connections