Re: PL/pgSQL and SETOF

From: "Pavel Stehule" <pavel(dot)stehule(at)gmail(dot)com>
To: "Cultural Sublimation" <cultural_sublimation(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: PL/pgSQL and SETOF
Date: 2007-11-30 17:16:25
Message-ID: 162867790711300916xd8cff12oceca31870c688332@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Dave Horn 2007-11-30 18:02:21 Postgres shutting down by itself...why?
Previous Message Sam Mason 2007-11-30 17:14:42 Re: PL/pgSQL and SETOF