Postgres Pro
Downloads
Home   >   mailing lists

text cast to bool bug - Mailing list pgsql-bugs

From Laczi József
Subject text cast to bool bug
Date
Msg-id 4BA1FB98.8090609@ritek.hu
Whole thread Raw
Responses Re: text cast to bool bug  (Pavel Stehule <pavel.stehule@gmail.com>)
Re: text cast to bool bug  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Tree view 
I think this is a funny bug:

select ('TRUE'::TEXT)::BOOL;bool
------f

but:

select ('TRUE'::varchar(4))::BOOL;bool
------tor

select ('true'::TEXT)::BOOL;bool
------t


My postgresql version:
PostgreSQL 8.3.4


Laczi József

pgsql-bugs by date:

Previous
From: Robert Haas
Date:
Subject: Re: Error when lock conflict on REPLACE function
Next
From: Pavel Stehule
Date:
Subject: Re: text cast to bool bug