Postgres Pro
Downloads
Home   >   mailing lists

minor problem in boolean cast - Mailing list pgsql-hackers

From Cary Huang
Subject minor problem in boolean cast
Date
Msg-id 17557e4dd97.fa5aae1a161459.7726916839177387693@highgo.ca
Whole thread Raw
Responses Re: minor problem in boolean cast  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view
Hi

I noticed that when casting a string to boolean value with input 'of' it still cast it to 'f'. I think with 'of', it should give an error because 'off' is the expected candidate. This may not be intended so I made a simple patch to address this. 

```
postgres=# select cast('of' as boolean);
bool
------
f
(1 row)
```


Cary Huang
-------------
HighGo Software Inc. (Canada)


Attachment

pgsql-hackers by date:

Previous
From: Mark Dilger
Date:
Subject: Re: new heapcheck contrib module
Next
From: Michael Paquier
Date:
Subject: Re: speed up unicode decomposition and recomposition