| From: | "Michael Gould" <mgould(at)intermodalsoftwaresolutions(dot)net> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | BUG #5356: citext not acting like case insensitive search |
| Date: | 2010-03-01 17:15:25 |
| Message-ID: | 201003011715.o21HFP5d074237@wwwmaster.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 5356
Logged by: Michael Gould
Email address: mgould(at)intermodalsoftwaresolutions(dot)net
PostgreSQL version: 8.4.2
Operating system: Windows 2008 R2 Server, Windows 7 x64
Description: citext not acting like case insensitive search
Details:
When we run the following query, we return no results.
Select citystateinfoid from iss.citystateinfo where cityname =
'JACKSONVILLE' and statecode = 'FL';
However this does work
Select citystateinfoid from iss.citystateinfo where cityname =
'Jacksonville' and statecode = 'FL'
The second query is how the data is actually stored. I've already forwarded
our ddl to david wheeler.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | David E. Wheeler | 2010-03-01 17:18:09 | Re: BUG #5356: citext not acting like case insensitive search |
| Previous Message | Andy Lester | 2010-03-01 16:18:37 | BUG #5355: locale incorrectly comma-separates "(null)" |