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.