Home > mailing lists

How can I return multiple rows from a FUNCTION? (revised) - Mailing list pgsql-sql

From	Ed Cox
Subject	How can I return multiple rows from a FUNCTION? (revised)
Date	December 5, 1998 22:38:10
Msg-id	000e01be20b0$4f310c60$600c2599@JEFFERSON Whole thread Raw
List	pgsql-sql

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

From: "Ed Cox"
Date: 05 December 1998, 22:36:03
Subject: How can I return multiple rows from a FUNCTION?

From: pierre
Date: 06 December 1998, 02:37:03
Subject: postmaster tuning commands