From: Thom Brown <thombrown@gmail.com>
To: pgsql-php@postgresql.org, PGSQL Mailing List <pgsql-general@postgresql.org>
Subject: PHP and PostgreSQL boolean data type
Date: Wed, 10 Feb 2010 12:04:23 +0000
Message-ID: <bddc86151002100404o76e1acc9r469d82a49284b7b5@mail.gmail.com> (raw)
Hi,
A long-standing problem we've had with PostgreSQL queries in PHP is
that the returned data for boolean columns is the string 'f' instead
of the native boolean value of false.
An obvious example of this would be for a table with users and their
boolean registered status:
Select user, registered From users;
Then getting a row from the result would reveal: array('user' =>
'thomb', registered => 'f');
Another problem is with arrays, where they are difficult to parse as
they also come through as plain strings with no binary alternative.
Is this a limitation of libpq or a flawed implementation in the php
library? And if this is just the case for backwards-compatibility, is
there a way to switch it to a more sensible PHP data type?
Thanks
Thom
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-php@postgresql.org
Cc: thombrown@gmail.com, pgsql-general@postgresql.org
Subject: Re: PHP and PostgreSQL boolean data type
In-Reply-To: <bddc86151002100404o76e1acc9r469d82a49284b7b5@mail.gmail.com>
References: <bddc86151002100404o76e1acc9r469d82a49284b7b5@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox