X-Original-To: pgsql-docs-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 530AD9FB225 for ; Mon, 21 Aug 2006 00:14:51 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 81335-01 for ; Mon, 21 Aug 2006 00:14:48 -0300 (ADT) X-Greylist: delayed 00:25:04.911828 by SQLgrey- Received: from sraigw.sra.co.jp (sraigw.sra.co.jp [202.32.10.2]) by postgresql.org (Postfix) with ESMTP id C1CDE9FB1F1 for ; Mon, 21 Aug 2006 00:00:06 -0300 (ADT) Received: from srascb.sra.co.jp (srascb [133.137.8.65]) by sraigw.sra.co.jp (Postfix) with ESMTP id 6748B62188 for ; Mon, 21 Aug 2006 11:35:09 +0900 (JST) Received: from srascb.sra.co.jp (localhost [127.0.0.1]) by localhost.sra.co.jp (Postfix) with ESMTP id 5035710CD04 for ; Mon, 21 Aug 2006 11:35:09 +0900 (JST) Received: from sranhm.sra.co.jp (sranhm [133.137.16.38]) by srascb.sra.co.jp (Postfix) with ESMTP id 2FD9A10CD07 for ; Mon, 21 Aug 2006 11:35:09 +0900 (JST) Received: from [127.0.0.1] (dhcp-17-240.sra.co.jp [133.137.17.240]) by sranhm.sra.co.jp (8.9.3+3.2W/3.7W-srambox) with ESMTP id LAA03222 for ; Mon, 21 Aug 2006 11:35:09 +0900 Message-ID: <44E91BD9.6010806@sra.co.jp> Date: Mon, 21 Aug 2006 11:35:05 +0900 From: Taiki Yamaguchi User-Agent: Thunderbird 1.5.0.5 (Windows/20060719) MIME-Version: 1.0 To: pgsql-docs@postgresql.org Subject: boolean type cast Content-Type: text/plain; charset=ISO-2022-JP Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200608/38 X-Sequence-Number: 3656 Hi, I found a minor glitch in the documentation for 8.1 where it talks about boolean data type. Here is what the documentation says: "Tip: Values of the boolean type cannot be cast directly to other types (e.g., CAST (boolval AS integer) does not work)." It is true for pre-8.1. As for 8.1, however, boolean type cast works: =# select true::int; int4 ------ 1 (1 row) regards, -- Taiki Yamaguchi