dbTalk Databases Forums  

[BUGS] boolean type cast

mailing.database.pgsql-bugs mailing.database.pgsql-bugs


Discuss [BUGS] boolean type cast in the mailing.database.pgsql-bugs forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Taiki Yamaguchi
 
Posts: n/a

Default [BUGS] boolean type cast - 08-21-2006 , 09:41 AM






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


---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.