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

From Pavel Stehule
Subject Re: PL/pgSQL and SETOF
Date
Msg-id 162867790711300916xd8cff12oceca31870c688332@mail.gmail.com
Whole thread Raw
In response to PL/pgSQL and SETOF  (Cultural Sublimation <cultural_sublimation@yahoo.com>)
List pgsql-general
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
>

pgsql-general by date:

Previous
From: Sam Mason
Date:
Subject: Re: PL/pgSQL and SETOF
Next
From: Cultural Sublimation
Date:
Subject: Re: PL/pgSQL and SETOF