Thread: Can the following be done?

Create or replace function foo(param1, param2, param3) RETURNS SETOF
RECORD(name TEXT, age INTEGER, address TEXT) AS ' ... ' LANGUAGE 'plpgsql';

If this is not possible, is there any way to have always the same names and
types for the returning columns when using SETOF RECORD?

Thanks

JuanF
(a newbie in evolution)

On Tue, 26 Aug 2003, Juan Francisco Diaz wrote:

> Create or replace function foo(param1, param2, param3) RETURNS SETOF
> RECORD(name TEXT, age INTEGER, address TEXT) AS ' ... ' LANGUAGE 'plpgsql';
>
> If this is not possible, is there any way to have always the same names and
> types for the returning columns when using SETOF RECORD?

You can make a composite type and return a set of that (you might want to
see http://techdocs.postgresql.org/guides/SetReturningFunctions )