pl/pgsql function out parameters

From: Richard Nfor <rnfor(at)taku(dot)demon(dot)co(dot)uk>
To: pgsql-general(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org
Subject: pl/pgsql function out parameters
Date: 2000-07-05 23:06:28
Message-ID: 3963BF74.5578D5D5@taku.demon.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

Hi there,

Does anyone know if out parameters are supported in pl/pgsql functions?

What I mean is something like this:

create function f(out int4) returns text as
'
select $1 = 3
return ""
' language 'plpgsql';

db ==> declare i int4;
db ==> select f(i);
db ==> select i;

i
==
3

I have scanned most of the plsql documentation I can lay hands on
without much joy
- mailing list archives
- User guide that is shipped with the postgres 7.02
- Programmer's guide shipped with release 7.02
- I notice that in the jdbc CallableStatement implementation,
registerOutpurParameter merely throws a notImplemented exception - Is
this a hint?
- Bruce Momjian's book - There is a chapter on functions and triggers,
but I cannot seem to find this mentioned anywhere.

If this is not doable, could someone please confirm that so I should
stop looking. On the other hand, if anyone out there has an idea how to
accomplish this, please, please help.

Kind regards,

Richard.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alex Pilosov 2000-07-05 23:06:58 Re: Re: Anyone using ReiserFS in production work? (or advise against it?)
Previous Message Jan Wieck 2000-07-05 22:50:38 Re: [HACKERS] Re: Revised Copyright: is this morepalatable?

Browse pgsql-hackers by date

  From Date Subject
Next Message The Hermit Hacker 2000-07-05 23:14:41 Re: fail in installing postgresql-6.5.3 to FreeBSD
Previous Message Tom Lane 2000-07-05 22:52:29 Re: fail in installing postgresql-6.5.3 to FreeBSD