Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 74A63632D9A for ; Thu, 11 Feb 2010 03:50:40 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 06426-04 for ; Thu, 11 Feb 2010 07:50:30 +0000 (UTC) Received: from news.hub.org (news.hub.org [200.46.204.72]) by mail.postgresql.org (Postfix) with ESMTP id 2D831632CEB for ; Thu, 11 Feb 2010 03:50:30 -0400 (AST) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.14.3/8.14.3) with ESMTP id o1B7oRgq083653 for ; Thu, 11 Feb 2010 03:50:27 -0400 (AST) (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.14.3/8.14.3/Submit) id o1B7gZng060446 for pgsql-general@postgresql.org; Thu, 11 Feb 2010 03:42:35 -0400 (AST) (envelope-from news) From: =?ISO-8859-1?Q?Torsten_Z=FChlsdorff?= X-Newsgroups: pgsql.general Subject: Re: PHP and PostgreSQL boolean data type Date: Thu, 11 Feb 2010 08:42:35 +0100 Organization: A noiseless patient Spider Lines: 18 Message-ID: References: Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Injection-Date: Thu, 11 Feb 2010 07:42:35 +0000 (UTC) Injection-Info: feeder.eternal-september.org; posting-host="AnkPUomeHXvuN7UdHvIkog"; logging-data="10356"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX19IS8PDMIQCIHSCMppc2Q/4" User-Agent: Mozilla/5.0 (X11; U; Linux i686; de; rv:1.8.1.23) Gecko/20090812 Thunderbird/2.0.0.23 Mnenhy/0.7.5.0 In-Reply-To: Cancel-Lock: sha1:DasMh66SRQXLz9h1YEp0TAcNDc0= To: pgsql-general@postgresql.org X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.001 tagged_above=-10 required=5 tests=BAYES_50=0.001 X-Spam-Level: X-Archive-Number: 201002/476 X-Sequence-Number: 159252 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.