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