pl/pgsql function out parameters - Mailing list pgsql-hackers

From Richard Nfor
Subject pl/pgsql function out parameters
Date
Msg-id 3963BF74.5578D5D5@taku.demon.co.uk
Whole thread Raw
List 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.

pgsql-hackers by date:

Previous
From: The Hermit Hacker
Date:
Subject: Re: Alternative new libpq interface.
Next
From: The Hermit Hacker
Date:
Subject: Re: Changes to handling version numbers internally