| From: | CaT <cat(at)zip(dot)com(dot)au> |
|---|---|
| To: | Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
| Cc: | Laczi József <laczi(dot)jozsef(at)ritek(dot)hu>, pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: text cast to bool bug |
| Date: | 2010-03-18 10:43:52 |
| Message-ID: | 20100318104352.GL2657@zip.com.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
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 <laczi(dot)jozsef(at)ritek(dot)hu>:
> > I think this is a funny bug:
> >
> > select ('TRUE'::TEXT)::BOOL;
> > bool
> > ------
> > f
...
> > select ('true'::TEXT)::BOOL;
> > bool
> > ------
> > t
--
"A search of his car uncovered pornography, a homemade sex aid, women's
stockings and a Jack Russell terrier."
- http://www.news.com.au/story/0%2C27574%2C24675808-421%2C00.html
| From | Date | Subject | |
|---|---|---|---|
| Next Message | lsasha | 2010-03-18 12:18:54 | BUG #5378: Little inaccuracy in the manual |
| Previous Message | Pavel Stehule | 2010-03-18 10:37:53 | Re: text cast to bool bug |