=?ISO-8859-2?Q?Laczi_J=F3zsef?= <laczi(dot)jozsef(at)ritek(dot)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