Re: PL/pgSQL and SETOF

From: Cultural Sublimation <cultural_sublimation(at)yahoo(dot)com>
To: Sam Mason <sam(at)samason(dot)me(dot)uk>, pgsql-general(at)postgresql(dot)org
Subject: Re: PL/pgSQL and SETOF
Date: 2007-11-30 18:12:40
Message-ID: 578170.14392.qm@web63401.mail.re1.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> 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...

Regards,
C.S.

____________________________________________________________________________________
Never miss a thing. Make Yahoo your home page.
http://www.yahoo.com/r/hs

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2007-11-30 18:18:04 Re: PL/pgSQL and SETOF
Previous Message Dave Horn 2007-11-30 18:02:21 Postgres shutting down by itself...why?