Re: Can the following be done?

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 )