Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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


pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group