Re: PL/pgSQL and SETOF

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
>