Re: PL/pgSQL and SETOF

[Cultural Sublimation <cultural_sublimation(at)yahoo(dot)com>]

> 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