I think this is a funny bug: select ('TRUE'::TEXT)::BOOL; bool ------ f
but: select ('TRUE'::varchar(4))::BOOL; bool ------ t or select ('true'::TEXT)::BOOL; bool ------ t My postgresql version: PostgreSQL 8.3.4 Laczi József -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs