db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Luiz Angelo Daros de Luca <lu...@ig.com.br>
Subject PostgreSQl don't delete rows with BOOELAN type
Date Mon, 19 Jan 2004 19:22:45 GMT
Hello,

    I have an table with a BOOLEAN type and when I ask torque to delete 
it, it generates a buggy SQL query.


DELETE FROM XXX WHERE blField = 0

The correct query in postgres would be

DELETE FROM XXX WHERE blField = '0'

or

DELETE FROM XXX WHERE blField = false

or even

DELETE FROM XXX WHERE blField = 'false'

I found out that org.apache.torque.adapter.DBPostgres return string "0" 
for False/NULL and "1" for true

Any ideas?

Thanks

    Luiz Angelo Daros de Luca


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org


Mime
View raw message