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 <[EMAIL PROTECTED]> http://svana.org/kleptog/
> Please line up in a tree and maintain the heap invariant while
> boarding. Thank you for flying nlogn airlines.
signature.asc
Description: Digital signature
