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

From Pavel Stehule
Subject Re: PL/pgSQL and SETOF
Date
Msg-id 162867790711301341v58b52df6p2203296aafd8ce7b@mail.gmail.com
Whole thread Raw
In response to 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, 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.
>
> Hmm, you are misunderstanding Cultural or I am.  I think his verbosity
> comment is not about the way the function is called, but rather about
> the function body itself.
>

It's my English. I am sorry. You have true.

Thank you for correction

Pavel

> --
> Alvaro Herrera       Valdivia, Chile   ICBM: S 39º 49' 18.1", W 73º 13' 56.4"
> "Before you were born your parents weren't as boring as they are now. They
> got that way paying your bills, cleaning up your room and listening to you
> tell them how idealistic you are."  -- Charles J. Sykes' advice to teenagers
>

pgsql-general by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: PL/pgSQL and SETOF
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Record variable not behaving as expected (bug?)