Postgres Pro
Downloads
Home   >   mailing lists

BUG #5356: citext not acting like case insensitive search - Mailing list pgsql-bugs

From Michael Gould
Subject BUG #5356: citext not acting like case insensitive search
Date
Msg-id 201003011715.o21HFP5d074237@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #5356: citext not acting like case insensitive search  ("David E. Wheeler" <david@kineticode.com>)
List pgsql-bugs
Tree view 
The following bug has been logged online:

Bug reference:      5356
Logged by:          Michael Gould
Email address:      mgould@intermodalsoftwaresolutions.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.

pgsql-bugs by date:

Previous
From: "Vitali"
Date:
Subject: BUG #5354: Type timestamptz doesn't allow to store time zone
Next
From: "David E. Wheeler"
Date:
Subject: Re: BUG #5356: citext not acting like case insensitive search