Re: text cast to bool bug - Mailing list pgsql-bugs

From Tom Lane
Subject Re: text cast to bool bug
Date
Msg-id 10329.1268922353@sss.pgh.pa.us
Whole thread Raw
In response to text cast to bool bug  (Laczi József <laczi.jozsef@ritek.hu>)
List pgsql-bugs
Laczi József <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


pgsql-bugs by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: BUG #5377: group by problem
Next
From: Tom Lane
Date:
Subject: Re: BUG #5377: group by problem