boolean type cast

From: Taiki Yamaguchi <yamaguchi(at)sraoss(dot)co(dot)jp>
To: pgsql-bugs(at)postgresql(dot)org
Subject: boolean type cast
Date: 2006-08-21 02:00:45
Message-ID: 44E913CD.6030101@sraoss.co.jp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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

Browse pgsql-bugs by date

  From Date Subject
Next Message Fujii Masao 2006-08-21 07:27:15 Re: BUG #2576: tcp_keepalive doesn't work
Previous Message Bruce Momjian 2006-08-19 18:21:11 Re: BUG #2579: initcap should not capitalize letter