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

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

Reply via email to