Re: Bug in boolean columns on win2k - Mailing list pgsql-bugs

On Wed, 15 Sep 2004, Mads Peter Henderson wrote:

> I have a table with the following column, from "psql \d":
> showemail    | boolean                     |
>
> When I try to insert data data into this through jdbc, I get the
> following error:
> java.sql.SQLException: ERROR: column "showemail" is of type boolean but
> expression is of type text


Are you using something like PreparedStatement.setString to compose this
query?  You should be using setBoolean instead I imagine.

Kris Jurka