From: | Christian Niles <christian(at)unit12(dot)net> |
---|---|
To: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | boolean and void CallableStatement return types |
Date: | 2004-10-26 16:06:11 |
Message-ID: | F495E5B1-2768-11D9-89C4-000A9590B78E@unit12.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Kris Jurka | 2004-10-26 17:19:07 | Re: boolean and void CallableStatement return types |
Previous Message | Alexey Yudichev | 2004-10-26 11:53:28 | Re: Problems with protocol V3 after migration to latest driver |