Re: Fwd: [JDBC] Weird issues when reading UDT from stored function
Lukas Eder <lukas.eder@gmail.com>
From: Lukas Eder <lukas.eder@gmail.com>
To: Robert Haas <robertmhaas@gmail.com>
Cc: Oliver Jowett <oliver@opencloud.com>, rsmogura <rsmogura@softperience.eu>, pgsql-jdbc@postgresql.org, pgsql-hackers@postgresql.org
Date: 2011-02-12T11:16:10Z
Lists: pgsql-hackers
I had tried that before. That doesn't seem to change anything. JDBC still expects 6 OUT parameters, instead of just 1... 2011/2/11 Robert Haas <robertmhaas@gmail.com> > On Tue, Jan 25, 2011 at 2:39 AM, Lukas Eder <lukas.eder@gmail.com> wrote: > > So what you're suggesting is that the plpgsql code is causing the issues? > > Are there any indications about how I could re-write this code? The > > important thing for me is to have the aforementioned signature of the > > plpgsql function with one UDT OUT parameter. Even if this is a bit > awkward > > in general, in this case, I don't mind rewriting the plpgsql function > > content to create a workaround for this problem... > > Possibly something like address := (SELECT ...) rather than SELECT ... > INTO address? > > -- > Robert Haas > EnterpriseDB: http://www.enterprisedb.com > The Enterprise PostgreSQL Company >