text cast to bool bug

Hello

It works on my server. Do you have a some specific configuration?

postgres=# select ('true'::text)::bool;
bool
------
t
(1 row)

I am checked 8.3, 8.4, 9.0.

Regards
Pavel Stehule

2010/3/18 Laczi József <laczi.jozsef@ritek.hu>:

On Thu, Mar 18, 2010 at 11:37:53AM +0100, Pavel Stehule wrote:

postgres=# select ('true'::text)::bool;
bool
------
t
(1 row)

I am checked 8.3, 8.4, 9.0.

What about the 'TRUE' (all caps) case? Note the blow:

2010/3/18 Laczi J�zsef <laczi.jozsef@ritek.hu>:

I think this is a funny bug:

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

...

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

--
"A search of his car uncovered pornography, a homemade sex aid, women's
stockings and a Jack Russell terrier."
- http://www.news.com.au/story/0%2C27574%2C24675808-421%2C00.html

=?ISO-8859-2?Q?Laczi_J=F3zsef?= <laczi.jozsef@ritek.hu> writes:

I think this is a funny bug:
select ('TRUE'::TEXT)::BOOL;
bool
------
f

Works here:

regression=# select ('TRUE'::TEXT)::BOOL;
bool
------
t
(1 row)

(I'm checking 8.3.10, but that code hasn't changed in a long time.)

Maybe you have created a custom text-to-bool cast that is catching this
operation, and the cast function is case-sensitive?

regards, tom lane