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(dot)jozsef(at)ritek(dot)hu>:
> 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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs
>