On Wed, Mar 26, 2008 at 2:58 PM, Seb <spluque@gmail.com> 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.