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.
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? |
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 |