On 09/11/2007 15:32, Cesar Alvarez wrote:
the Pipelined is the statement so the functions knows he is returning rows.
Yes, you can write functions returning rows in pl/pgsql - see the docs,
specifically the RETURN NEXT statement. Then the syntax is:
select * from my_function();
- the function takes the place of a table in the SELECT statement.
HTH
Ray.
---------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@xxxxxx
---------------------------------------------------------------
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
