On Wed, Mar 26, 2008 at 05:28:18PM -0500, Seb wrote: > > INSERT INTO my_table (var_bool) VALUES ( CAST( 0 AS BOOLEAN )); or > > INSERT INTO my_table (var_bool) VALUES (0::BOOLEAN); > > Thanks Richard. Is there a way to do it without changing the INSERT > command? As I mentioned, there are many more columns of different > types, so finding and replacing the VALUES would be very difficult. Don't think anyone mentioned it, but if you could get it to output quotes around the value, like: INSERT INTO my_table (var_bool) VALUES ('0'); It will also work. Have a nice day, -- Martijn van Oosterhout <kleptog@xxxxxxxxx> http://svana.org/kleptog/ > Please line up in a tree and maintain the heap invariant while > boarding. Thank you for flying nlogn airlines.
Attachment:
signature.asc
Description: Digital signature