Re: Invoking a function within a batch statement

Thanks for the replies. I was under the impression that the `{call ...}`
syntax in JDBC only applied to stored procedures, so that's good to know
regarding functions that return refcursors. However, as Example 6.2 on that
page <https://jdbc.postgresql.org/documentation/94/callproc.html>
illustrates, one must use SELECT to invoke functions that return SETOF
results.

In my use case, the function boils down to the invocation of an INSERT
statement, so there is no result. And more generally, it seems to me that
JDBC should support the batch SETOF-returning function use case. That is to
say, JDBC probably shouldn't reject non-none results as it currently seems
to be.

On Wed, Aug 17, 2016 at 8:16 AM, rob stone <floriparob(at)gmail(dot)com> wrote:

>
> On Wed, 2016-08-17 at 15:06 +0000, Vitalii Tymchyshyn wrote:
> > I think you should be able to use {call proc(params)} form, see https
> > ://jdbc.postgresql.org/documentation/80/callproc.html
> > Best regards, Vitalii Tymchyshyn
> >
>
> Or see https://jdbc.postgresql.org/documentation/94/callproc.html
>
> which is the latest doco.
>
> Note that 1209 is the most recent driver.
>
> HTH,
> rob
>

--
Evan Meagher