Re: [GENERAL] PL/pgSQL and SETOF

From: Cultural Sublimation <cultural_sublimation(at)yahoo.com>
Date: Fri Nov 30 2007 - 13:12:40 EST

> 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

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

TIP 6: explain analyze is your friend Received on Fri Nov 30 13:13:34 2007