Re: return row from plpgsql?

From: zhong ming wu <mr(dot)z(dot)m(dot)wu(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: return row from plpgsql?
Date: 2010-03-17 11:07:09
Message-ID: 9e434c4d1003170407p7d4d040cpc3da199d35bd3b67@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Mar 17, 2010 at 12:00 AM, Osvaldo Kussama
<osvaldo(dot)kussama(at)gmail(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Craig Ringer 2010-03-17 11:34:06 Re: stopping processes, preventing connections
Previous Message Pavel Stehule 2010-03-17 10:53:36 Re: Avoiding SQL injection in Dynamic Queries (in plpgsql)