Re: Function nesting issue - Mailing list pgsql-general

From Tom Lane
Subject Re: Function nesting issue
Date
Msg-id 15424.1264693871@sss.pgh.pa.us
Whole thread Raw
In response to Re: Function nesting issue  (张海峰 <roxetter@gmail.com>)
List pgsql-general
=?GB2312?B?1cW6o7fl?= <roxetter@gmail.com> writes:
> And i call function a by jdbc:
> ...
> conn.setAutoCommit(false);
> CallableStatement cs = conn.prepareCall("{ call a( ?, ? ) }");
> cs.registerOutParameter(1, Types.INTEGER);
> cs.registerOutParameter(2, Types.OTHER);
> cs.execute();

That's not the approved syntax for using OUT parameters in Postgres.
It's possible that JDBC would do something under-the-hood to make it
look like it works, but you'd be best off asking on pgsql-jdbc about
whether they do or not.

            regards, tom lane

pgsql-general by date:

Previous
From: Andy Colson
Date:
Subject: Re: dynamic crosstab
Next
From: Joshua Tolley
Date:
Subject: Re: query a table from one database to another