Re: UTF-8 and LIKE vs =

Поиск
Список
Период
Сортировка
От Lincoln Yeoh
Тема Re: UTF-8 and LIKE vs =
Дата
Msg-id 5.2.1.1.1.20040827005444.02ed6ba0@localhost
обсуждение исходный текст
Ответ на Re: UTF-8 and LIKE vs =  (David Wheeler <david@kineticode.com>)
Список pgsql-general
At 09:41 AM 8/26/2004 -0700, David Wheeler wrote:

>>What would be useful would be functions to allow selects etc to be
>>ordered as if under different query specifiable locales.
>
>Wouldn't that require different indexes for the different locales? (Where
>there are indexes, of course.)

That's optional I think - depends on amount of data selected and how
selective the indexes would be.

It should be just like any other index on a function- like having an index
on lower(text).

You have index on locale('korean',text) and so on.

Not really sure how to do that tho :). Anyone have ideas?

Should be possible right?

Link.

В списке pgsql-general по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: R: R: space taken by a row & compressed data
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Stored procedure failure