Re: PL/pgSQL and SETOF - Mailing list pgsql-general

From Pavel Stehule
Subject Re: PL/pgSQL and SETOF
Date
Msg-id 162867790711301331m78e45ceg4b5fa02cef251fdd@mail.gmail.com
Whole thread Raw
In response to Re: PL/pgSQL and SETOF  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Responses Re: PL/pgSQL and SETOF  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
List pgsql-general
On 30/11/2007, Alvaro Herrera <alvherre@alvh.no-ip.org> wrote:
> Pavel Stehule escribió:
> > On 30/11/2007, Cultural Sublimation <cultural_sublimation@yahoo.com> wrote:
>
> > > But still on that subject: is my version of get_items2 the simplest
> > > that is possible in PL/pgSQL?  It seems awfully verbose compared to
> > > the SQL version...
> >
> > no. Your simplest version is historic relict and is available only in
> > sql language. I am not sure, maybe in C language too.
>
> But isn't the case that on 8.3 you would be able to rewrite it more
> easily using RETURN QUERY?
>

yes. sure. But it is different question than call SRF function in
normal context.

Pavel


> --
> Alvaro Herrera                          Developer, http://www.PostgreSQL.org/
> "Pido que me den el Nobel por razones humanitarias" (Nicanor Parra)
>

pgsql-general by date:

Previous
From: Pascal Cohen
Date:
Subject: HA and Replication - how to choose among all the available solutions
Next
From: Alvaro Herrera
Date:
Subject: Re: PL/pgSQL and SETOF