From: | Mithun Bhattacharya <mithun(dot)b(at)egurucool(dot)com> |
---|---|
To: | PostgreSQL general <pgsql-general(at)postgresql(dot)org> |
Subject: | Another DBD::Pg question |
Date: | 2001-07-06 14:25:52 |
Message-ID: | 3B45CA70.4939A20F@egurucool.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
This time perldoc DBD::Pg says :
----------------
Data-Type bool
The current implementation of PostgreSQL returns 't' for
true and 'f' for false. From the perl point of view a
rather unfortunate choice. The DBD-Pg module translates
the result for the data-type bool in a perl-ish like
manner: 'f' -> '0' and 't' -> '1'. This way the
application does not have to check the database-specific
returned values for the data-type bool, because perl
treats '0' as false and '1' as true.
PostgreSQL Version 6.2 considers the input 't' as true and
anything else as false. PostgreSQL Version 6.3 considers
the input 't', '1' and 1 as true and anything else as
false. PostgreSQL Version 6.4 considers the input 't',
'1' and 'y' as true and any other character as false.
----------------
Anyone using DBD::PG version 1.00 with PostGreSQL version 7.1.2 ?? If so
whats the interpretation of true in that.. The Author doesnt say what
his current implementation is.
Mithun
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2001-07-06 14:32:54 | Re: [SQL] Cross database foreign keys |
Previous Message | Trewern, Ben | 2001-07-06 14:25:49 | Vacuum and Transactions |