Re: [BUGS] text cast to bool bug

=?ISO-8859-2?Q?Laczi_J=F3zsef?= 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

Re: [BUGS] text cast to bool bug

On Thu, Mar 18, 2010 at 11:37:53AM +0100, Pavel Stehule wrote: > postgres=# select ('true'::text)::bool; > bool > -- > t > (1 row) > > I am checked 8.3, 8.4, 9.0. What about the 'TRUE' (all caps) case? Note the blow: > 2010/3/18 Laczi József : > > I think this is a funny bug: > > > > selec

Re: [BUGS] text cast to bool bug

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 : > I think this is a funny bug: > > select ('TRUE'::TEXT)::BOOL; > bool > -- > f

[BUGS] text cast to bool bug

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