Re: Can the following be done?

От:

Stephan Szabo <sszabo@megazone.bigpanda.com>

Дата:

26 августа 2003 г. в 16:43:57


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 )

Can the following be done?

От:

Juan Francisco Diaz <j-diaz@publicar.com>

Дата:

26 августа 2003 г. в 16:10:55

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)