db-torque-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Matt Finn <m...@bitcount.com>
Subject Re: Postgres aapter bug
Date Tue, 29 Apr 2003 02:35:23 GMT
Hi,

I have also been afflicted with that problem.
How about using single quotes for booleans ('0' and '1')? This works 
fine with 7.2 and 7.3 postgres across all three types, although I 
haven't tested any earlier versions.

postgres=# create table test (one boolean, two char, three int2);
CREATE TABLE
postgres=# insert into test (one,two,three) values ('0','0','0');
INSERT 43810 1
postgres=# insert into test (one,two,three) values ('1','1','1');
INSERT 43811 1
postgres=# select * from test;
  one | two | three
-----+-----+-------
    0 | f   | 0
    1 | t   | 1
(2 rows)

postgres=#


-matt




Mime
View raw message