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

From: spatarel1(at)yahoo(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #6743: BETWEEN operator does not work for char(1)
Date: 2012-07-18 12:39:30
Message-ID: E1SrTXO-0003XB-HO@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 6743
Logged by: Spătărel Dan
Email address: spatarel1(at)yahoo(dot)com
PostgreSQL version: 9.1.4
Operating system: Windows Vista SP2
Description:

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 'z'; -- false (!)
SELECT 'a' BETWEEN 'A' AND 'Z'; -- false (!)
SELECT 'z' BETWEEN 'A' AND 'Z'; -- true
SELECT 'A' BETWEEN 'A' AND 'Z'; -- true
SELECT 'Z' BETWEEN 'A' AND 'Z'; -- true

It seems that the intent is for the comparison to be case-insensitive, but
in some limit-cases it fails.

Please let me know if this turns out to be a real bug on not.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Alexander Law 2012-07-18 15:05:07 Re: BUG #6742: pg_dump doesn't convert encoding of DB object names to OS encoding
Previous Message Alexander Law 2012-07-18 08:51:34 Re: BUG #6742: pg_dump doesn't convert encoding of DB object names to OS encoding