Horton

Re: Fwd: [JDBC] Weird issues when reading UDT from stored function

Radosław Smogura <rsmogura@softperience.eu>

View thread
From: rsmogura <rsmogura@softperience.eu>
To: Oliver Jowett <oliver@opencloud.com>
Cc: Florian Pflug <fgp@phlo.org>, Tom Lane <tgl@sss.pgh.pa.us>, Robert Haas <robertmhaas@gmail.com>, Lukas Eder <lukas.eder@gmail.com>, <pgsql-jdbc@postgresql.org>, <pgsql-hackers@postgresql.org>
Date: 2011-02-17T11:37:38Z
Lists: pgsql-hackers 
 On Fri, 18 Feb 2011 00:06:22 +1300, Oliver Jowett wrote:
> On 17/02/11 23:18, rsmogura wrote:
>> Yes, but driver checks number of declared out parameters and number 
>> of
>> resulted parameters (even check types of those), to prevent 
>> programming
>> errors.
>
> And..?
>
> Oliver

 And it will throw exception when result will income. If you will remove 
 this then you will lose check against programming errors, when number of 
 expected parameters is different that number of actual parameters. Bear 
 in mind that you will get result set of 6 columns, but only 1 is 
 expected. I think you can't determine what should be returned and how to 
 fix result without signature.