Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 283E9632D93 for ; Wed, 10 Feb 2010 10:20:34 -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 31682-10 for ; Wed, 10 Feb 2010 14:20:23 +0000 (UTC) Received: from news.hub.org (news.hub.org [200.46.204.72]) by mail.postgresql.org (Postfix) with ESMTP id DCB9A632BC6 for ; Wed, 10 Feb 2010 10:20:23 -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 o1AEKF3B089558 for ; Wed, 10 Feb 2010 10:20:15 -0400 (AST) (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.14.3/8.14.3/Submit) id o1AEFFGg088400 for pgsql-general@postgresql.org; Wed, 10 Feb 2010 10:15:15 -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: Wed, 10 Feb 2010 15:15:18 +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: Wed, 10 Feb 2010 14:15:19 +0000 (UTC) Injection-Info: feeder.eternal-september.org; posting-host="AnkPUomeHXvuN7UdHvIkog"; logging-data="26165"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX19u8xNtCUpHiCSLkIslW4iR" 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:8pZPa6fX3LgwLSZo/bXuOoltxwY= 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/479 X-Sequence-Number: 159255 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.