Re: PHP and PostgreSQL boolean data type

From: Torsten Zühlsdorff <foo(at)meisterderspiele(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: PHP and PostgreSQL boolean data type
Date: 2010-02-11 07:42:35
Message-ID: hl0cdb$a3k$1@news.eternal-september.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-php

Thom Brown schrieb:

> 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.

This problem is solved since nearly 5 years with PDO. You can use an
abstraction like DDDBL (see my signature) if you want to save time while
using PDO.

Greetings from Germany,
Torsten

--
http://www.dddbl.de - ein Datenbank-Layer, der die Arbeit mit 8
verschiedenen Datenbanksystemen abstrahiert,
Queries von Applikationen trennt und automatisch die Query-Ergebnisse
auswerten kann.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Carsten Kropf 2010-02-11 07:54:12 Re: Extending SQL in C using VARIABLE length type
Previous Message Tom Lane 2010-02-11 07:04:12 Re: questions about a table's row estimates

Browse pgsql-php by date

  From Date Subject
Next Message Jasen Betts 2010-02-12 09:13:54 Re: PHP and PostgreSQL boolean data type
Previous Message Chris 2010-02-10 21:56:36 Re: [PHP] PHP and PostgreSQL boolean data type