Re: PL/pgSQL and SETOF - Mailing list 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