Re: [BUGS] BUG #6743: BETWEEN operator does not work for char(1)

2012-07-19 Thread Tom Lane
spatar...@yahoo.com writes: I use UTF8 charset and Romania, Romanian locale. I came across this as I wanted to test if a symbol was a letter: SELECT 'a' BETWEEN 'a' AND 'z'; -- true SELECT 'z' BETWEEN 'a' AND 'z'; -- true SELECT 'A' BETWEEN 'a' AND 'z'; -- true SELECT 'Z' BETWEEN 'a' AND

[BUGS] BUG #6743: BETWEEN operator does not work for char(1)

2012-07-18 Thread spatarel1
The following bug has been logged on the website: Bug reference: 6743 Logged by: Spătărel Dan Email address: spatar...@yahoo.com PostgreSQL version: 9.1.4 Operating system: Windows Vista SP2 Description: I use UTF8 charset and Romania, Romanian locale. I came across