Обсуждение: Function returning multiple data

Поиск
Список
Период
Сортировка

Function returning multiple data

От
Jean-Christophe Boggio
Дата:
Hi,

I'm quite new to PG (coming from Oracle) and I can't create a function
that will send back multiple results, something like :

create function two_choices(id1 out text, id2 out text)
as '
begin
  id1:='some text';
  id2:='some other text';
end;' language 'plpgsql';

Is this possible without creating a dedicated type for every such
function ?

TIA,

--
Jean-Christophe Boggio
cat@thefreecat.org
Independant Consultant and Developer
Delphi, Linux, Oracle, Perl