On Wed, 26 Mar 2008 15:11:47 -0700, "Richard Broersma" <richard.broersma@xxxxxxxxx> 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. -- Seb -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general