Re: text cast to bool bug

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Laczi József <laczi(dot)jozsef(at)ritek(dot)hu>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: text cast to bool bug
Date: 2010-03-18 14:25:53
Message-ID: 10329.1268922353@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

=?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

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2010-03-18 14:44:23 Re: BUG #5377: group by problem
Previous Message Kevin Grittner 2010-03-18 13:34:36 Re: BUG #5377: group by problem