From: | "Kevin Grittner" <kgrittn(at)mail(dot)com> |
---|---|
To: | "Thomas" <thomas(dot)k(dot)hill(at)t-online(dot)de>,pgsql-general(at)postgresql(dot)org |
Subject: | Re: Experiences with pl/Java |
Date: | 2012-11-21 02:08:52 |
Message-ID: | 20121121020852.156410@gmx.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Thomas wrote:
> have tested further combinations - without success - any other
> idea?
> [attempts to use Java parameter list for PostgreSQL OUT parameters]
My guess is that for a single PostgreSQL OUT parameter you should
make your Java function return a value of that type and omit the
parameter from the Java function signature. PostgreSQL implements OUT
parameters in a different way from what I've seen in other products:
a single OUT parrameter is the same as specifying the type in the
RETURNS for the function. Specifying multiple OUT parameters returns
a record with matching fields.
That always seems odd to me, but at this point it is very unlikely to
change.
-Kevin
From | Date | Subject | |
---|---|---|---|
Next Message | Kevin Grittner | 2012-11-21 02:26:30 | Re: Maintaining state across function calls |
Previous Message | Gavin Flower | 2012-11-20 23:06:48 | Re: High SYS CPU - need advise |