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
