Thread: boolean and void CallableStatement return types

boolean and void CallableStatement return types

From
Christian Niles
Date:
Hi All,

If I define a function that returns a boolean value, the JDBC interface
throws an error because the reported return type is actually Types.BIT.
I noticed this was asked at least twice before, once a year ago, and
once again 2 years ago. No responses were given in the list, as far as
I could see.

Also, if I have a CallableStatement such as "{call void_func()}", which
returns void, the server reports an error:

ERROR:  function "void_func" in FROM has unsupported return type

This is the same error as if the function were called as SELECT * FROM
void_func():

test=# SELECT * FROM void_func();
ERROR:  function "void_func" in FROM has unsupported return type

Are both of these known/expected behaviors?

best,
christian.


Re: boolean and void CallableStatement return types

From
Kris Jurka
Date:

On Tue, 26 Oct 2004, Christian Niles wrote:

> If I define a function that returns a boolean value, the JDBC interface
> throws an error because the reported return type is actually Types.BIT.
> I noticed this was asked at least twice before, once a year ago, and
> once again 2 years ago. No responses were given in the list, as far as
> I could see.

I've just commited a fix to the driver to make this work.

> test=# SELECT * FROM void_func();
> ERROR:  function "void_func" in FROM has unsupported return type
>

I submitted a patch a week ago or so that fixes this on the server side.
It is in 8.0beta4.

Kris Jurka