Re: BUG #4920: need case-insensitive searches
От | Joshua Tolley |
---|---|
Тема | Re: BUG #4920: need case-insensitive searches |
Дата | |
Msg-id | 20090714133731.GS31174@eddie обсуждение исходный текст |
Ответ на | BUG #4920: need case-insensitive searches ("Michael Gould" <mgould@intermodalsoftwaresolutions.net>) |
Ответы |
Re: BUG #4920: need case-insensitive searches
|
Список | pgsql-bugs |
On Tue, Jul 14, 2009 at 01:28:30PM +0000, Michael Gould wrote: > 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 loc= ale > 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.=20=20 In 8.4, the citext module provides you a case-insensitive data type. In earlier versions, you might store uppper(text_field) in the database instead of or in addition to the original text_field value. http://www.postgresql.org/docs/current/static/citext.html -- Joshua Tolley / eggyknap End Point Corporation http://www.endpoint.com
В списке pgsql-bugs по дате отправления: