Home > mailing lists

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

From	Ed Cox
Subject	How can I return multiple rows from a FUNCTION?
Date	December 5, 1998 22:36:03
Msg-id	000001be20b0$028d4c20$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 count(*) 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: Thomas Good
Date: 04 December 1998, 19:53:59
Subject: Re: [SQL] DBD

From: "Ed Cox"
Date: 05 December 1998, 22:38:10
Subject: How can I return multiple rows from a FUNCTION? (revised)