Function returning multiple data - Mailing list pgsql-novice

From Jean-Christophe Boggio
Subject Function returning multiple data
Date
Msg-id 907910169.20001012154702@thefreecat.org
Whole thread Raw
List pgsql-novice
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



pgsql-novice by date:

Previous
From: "S.A.Pamungkas"
Date:
Subject: download postgresql for windows
Next
From: "Kevin Leclaire"
Date:
Subject: Importing Data into Postgresql from MS Access