Home > mailing lists

Thread: How can I return multiple rows from a FUNCTION? (revised)

How can I return multiple rows from a FUNCTION? (revised)

From

"Ed Cox"

Date:

05 December 1998, 22:38:10

Is it possible to have a FUNCTION in Postgres that returns multiple rows? Something like:

CREATE FUNCTION foo()

RETURNS ???

AS 'SELECT * FROM bar'

LANGUAGE 'sql';

If not, can you suggest a way to encapsulate this functionality? I'd like to keep all SQL code out of my GSP code.

Thanks very much,

Ed Cox