Re: [GENERAL] PL/pgSQL and SETOF

From: Pavel Stehule <pavel.stehule(at)gmail.com>
Date: Fri Nov 30 2007 - 12:16:25 EST

Hello

> Unfortunately it doesn't work! Postgresql complains that "set-valued
> function called in context that cannot accept a set". Anyway, what am
> I doing wrong, and what is the simplest way of translating get_items
> in PL/pgSQL?
>
> Thanks in advance!
> C.S.

try

select * from get_items2()

Regards
Pavel Stehule
>
>
>
> ____________________________________________________________________________________
> Get easy, one-click access to your favorites.
> Make Yahoo! your homepage.
> http://www.yahoo.com/r/hs
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: don't forget to increase your free space map settings
>

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

TIP 6: explain analyze is your friend Received on Fri Nov 30 12:17:45 2007