Re: Function nesting issue
От
Tom Lane
Тема
Re: Function nesting issue
Дата
Msg-id
15424.1264693871@sss.pgh.pa.us
Ответ на
Список
Дерево обсуждения
Function nesting issue 张海峰 <roxetter@gmail.com>
Re: Function nesting issue Raymond O'Donnell <rod@iol.ie>
Re: Function nesting issue 张海峰 <roxetter@gmail.com>
Re: Function nesting issue Tom Lane <tgl@sss.pgh.pa.us>
=?GB2312?B?1cW6o7fl?= 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 по дате отправления
