Skip site navigation (1) Skip section navigation (2)

Re: boolean and void CallableStatement return types

From: Kris Jurka <books(at)ejurka(dot)com>
To: Christian Niles <christian(at)unit12(dot)net>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: boolean and void CallableStatement return types
Date: 2004-10-26 17:19:07
Message-ID: Pine.BSO.4.56.0410261217360.2019@leary.csoft.net (view raw or flat)
Thread:
Lists: pgsql-jdbc

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

In response to

pgsql-jdbc by date

Next:From: Kris JurkaDate: 2004-10-26 17:26:39
Subject: Re: Problems with protocol V3 after migration to latest driver
Previous:From: Christian NilesDate: 2004-10-26 16:06:11
Subject: boolean and void CallableStatement return types

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group