> 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
