Re: Case insensitive selects?
От | David Wheeler |
---|---|
Тема | Re: Case insensitive selects? |
Дата | |
Msg-id | Pine.LNX.4.21.0102150826080.16929-100000@theory обсуждение исходный текст |
Ответ на | Re: Case insensitive selects? (Michael Fork <mfork@toledolink.com>) |
Ответы |
Re: Case insensitive selects?
|
Список | pgsql-general |
On Thu, 15 Feb 2001, Michael Fork wrote: > Indexes *can* and *will* be used if you create the appropiate > functional indexes, i.e: > > CREATE INDEX idx_table_field_upper ON table(upper(field)); > > SELECT field FROM table WHERE upper(field) LIKE upper('some string'); Hmmm...I'd hate to have two indexes on every field I query like this, one case-senstive, one case-insensitve (like the one you create here). Is there a configuration option or something that will tell pgsql to do case-insensitive comparisons (kinda like MS SQL Server has)? That could save us on indexing overhead, since we want all of our WHERE comparisons to be case-insensitive, anyway. I should also not that we're also using --with-multibyte and having all of our databases use Unicode exclusively. Thanks! David
В списке pgsql-general по дате отправления: