Another DBD::Pg question

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

Responses

Browse pgsql-general by date

  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