return two elements
От | Rodríguez Rodríguez, Pere |
---|---|
Тема | return two elements |
Дата | |
Msg-id | B35596C2EFF3D2118EE100A0C94B2A60014BFBDC@palamos_nt обсуждение исходный текст |
Ответы |
Re: return two elements
Re: return two elements Re: return two elements |
Список | pgsql-general |
Hello,
how can I write a function that return two or more elements?
I try to return a record but after I don't know how to assign returned value to a variable. For example,
CREATE OR REPLACE FUNCTION test1() RETURNS record AS '
declare
rec record;
begin
select into rec \'01/01/2005\'::Date as dt_inici, \'02/02/2005\'::Date as dt_fi;
return rec;
end; '
LANGUAGE 'plpgsql' VOLATILE;
CREATE OR REPLACE FUNCTION test2() RETURNS date AS '
declare
rec record;
begin
-- rec := test1(); << ERROR: syntax error at or near "rec"
select into rec test1();
return rec.dt_inici; << ERROR: record "rec" has no field "dt_inici"
end; '
LANGUAGE 'plpgsql' VOLATILE;
Can I return an array?, and how I take returned array?
I search postgres documentation but I don't find it
Thanks in advance,
pere
В списке pgsql-general по дате отправления: