Re: [GENERAL] PL/pgSQL and SETOF

From: Pavel Stehule <pavel.stehule(at)gmail.com>
Date: Fri Nov 30 2007 - 13:18:04 EST

On 30/11/2007, Cultural Sublimation <cultural_sublimation@yahoo.com> wrote:
> > I would guess you're calling it like:
> >
> > SELECT get_items2();
> >
> > whereas, you should call set returning functions like:
> >
> > SELECT * FROM get_items2();
>
> Hi,
>
> Yeah, that was the problem -- thanks!
>
> 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.

Pavel

> Regards,
> C.S.
>
>
>
> ____________________________________________________________________________________
> Never miss a thing. Make Yahoo your home page.
> http://www.yahoo.com/r/hs
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>

---------------------------(end of broadcast)---------------------------

TIP 4: Have you searched our list archives?

               http://archives.postgresql.org/ Received on Fri Nov 30 13:18:49 2007