Function returning multiple data

From: Jean-Christophe Boggio <cat(at)thefreecat(dot)org>
To: pgsql-novice(at)postgresql(dot)org
Subject: Function returning multiple data
Date: 2000-10-12 13:47:02
Message-ID: 907910169.20001012154702@thefreecat.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)thefreecat(dot)org
Independant Consultant and Developer
Delphi, Linux, Oracle, Perl

Browse pgsql-novice by date

  From Date Subject
Next Message Fernando M. Maresca 2000-10-12 18:09:09 Need more help on data bases over a intranet
Previous Message S.A.Pamungkas 2000-10-12 11:44:47 download postgresql for windows