PostgreSQl don't delete rows with BOOELAN type

[Luiz Angelo Daros de Luca]

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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]