On 30/11/2007, Cultural Sublimation <[EMAIL PROTECTED]> wrote: > > 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... >
no. Your simplest version is historic relict and is available only in sql language. I am not sure, maybe in C language too. Pavel > 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 > ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org/
