From: | Kris Jurka <books(at)ejurka(dot)com> |
---|---|
To: | Srivats <scshekaran(at)newbreak(dot)com> |
Cc: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: name value pairs |
Date: | 2005-11-05 08:12:44 |
Message-ID: | Pine.BSO.4.61.0511050308460.25112@leary.csoft.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
On Fri, 4 Nov 2005, Srivats wrote:
> Can I call the functions with name value pairs from JAVA like i do in Sybase.
> For Example
> function name ( variable name = value, ..... );
The CallableStatement interface provides setXXX methods that take a String
argument for the parameter name in addition to the integer offset setXXX
methods. Unfortunately the postgresql jdbc driver currently does not
implement these methods.
It would be possible to implement this method by parsing the statement and
then querying the system catalog to get the function parameters' names.
This wouldn't work for overloaded functions which need additional type
information to resolve, but I don't think that's the general case.
Kris Jurka
From | Date | Subject | |
---|---|---|---|
Next Message | Kris Jurka | 2005-11-05 09:31:20 | Re: semicolons separating statements in a rule action body |
Previous Message | pavi thra | 2005-11-05 04:54:22 | doubt |