On Wed, Mar 26, 2008 at 2:58 PM, Seb <[EMAIL PROTECTED]> wrote: > INSERT INTO my_table (var_bool) VALUES (0); > INSERT INTO my_table (var_bool) VALUES (1); > > So this results in an error. Unfortunately, there are many more columns > and it would be very difficult to write a regexp to replace the 0s and > 1s with their quoted versions. Is there any way to make such INSERT > commands be valid? I have no experience with CAST, so any pointers > would be welcome. Thanks.
INSERT INTO my_table (var_bool) VALUES ( CAST( 0 AS BOOLEAN )); or INSERT INTO my_table (var_bool) VALUES (0::BOOLEAN); -- Regards, Richard Broersma Jr. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
