Re: Experiences with pl/Java - Mailing list pgsql-general

From Kevin Grittner
Subject Re: Experiences with pl/Java
Date
Msg-id 20121121020852.156410@gmx.com
Whole thread Raw
In response to Experiences with pl/Java  (Thomas Hill <Thomas.K.Hill@t-online.de>)
List 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


pgsql-general by date:

Previous
From: Gavin Flower
Date:
Subject: Re: High SYS CPU - need advise
Next
From: "Kevin Grittner"
Date:
Subject: Re: Maintaining state across function calls