[BUGS] BUG #4920: need case-insensitive searches
The following bug has been logged online: Bug reference: 4920 Logged by: Michael Gould Email address: mgo...@intermodalsoftwaresolutions.net PostgreSQL version: all Operating system: Windows 2008 Server Description:need case-insensitive searches Details: I can see why people use case sensitive searches but it would be nice if there was either a setup option in the init program or a encoding and locale that would allow for case insenstive searches without having to use a non-standard Ilike search. In out database for example, we have no text fields that need a case sensitive index or search. I'm sure I'm not the only one who could use this feature. I remember years ago I was told that Sybase ASE was case sensitive only but the dba found a encoding and locale that allowed for case insensitive searches. Unless Postgres doesn't have a performance problem with upper(column) = upper(column) then I would think it would be avantageous to support case insensitive searches in which indexes could also be case insensitive. Best Regards Michael Gould -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
[BUGS] BUG #5356: citext not acting like case insensitive search
The following bug has been logged online: Bug reference: 5356 Logged by: Michael Gould Email address: mgo...@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. -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
