return two elements

Поиск
Список
Период
Сортировка
От Rodríguez Rodríguez, Pere
Тема return two elements
Дата
Msg-id B35596C2EFF3D2118EE100A0C94B2A60014BFBDC@palamos_nt
обсуждение исходный текст
Ответы Re: return two elements  (Franco Bruno Borghesi <fborghesi@gmail.com>)
Re: return two elements  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: return two elements  ("Franco Bruno Borghesi" <fborghesi@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: John Sidney-Woollett
Дата:
Сообщение: Re: Download mirrors not found?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: pg_dump 8.0.3 failing against PostgreSQL 7.3.2