boolean DBD::Pg

[Ingo Wichmann]

Hi!

i get an error when i try to save the value 1 in an boolean column. Here is an excerpt from perl -d:

> p $insert_string
INSERT INTO Nullpunkt (
..., (erased non relevant code)
zentraler_Nullpunkt,
... (erased non relevant code)
) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?);
> p join " - ", @values
... - 1 - ...
> my $sth = $dbh->prepare($insert_string) or carp $DBI::errstr;
> if ($sth->execute(@values)) {
DBD::Pg::st execute failed: ERROR: column "zentraler_nullpunkt" is of type 'boolean' but expression is of type 'integer' at Postgresql.pm line 199.

Do i have to convert 1 into "t"?

I'm using perl 5.6.1, $DBD::Pg::VERSION = '1.13'; and postgresql 7.2 on Linux.

Ingo