On 09/11/2009 22:43, Raymond O'Donnell wrote: > On 19:59, wrote: >> how can I write a function to return multiple rows? ( in plpgsql ) > > Yep, it's all in the docs: > > http://www.postgresql.org/docs/8.4/static/plpgsql-control-structures.html#PLPGSQL-STATEMENTS-RETURNING [snip] > Finally, you can use OUT parameters to return multiple values from the > function - this is handy if you need to return just a few values. Just to clarify further - this last option returns just a single row. Ray. -- Raymond O'Donnell :: Galway :: Ireland rod@xxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
