Re: Case insensitive collation

Поиск
Список
Период
Сортировка
От Alban Hertroys
Тема Re: Case insensitive collation
Дата
Msg-id CAF-3MvNsNHPmQoVUmbQrELKZ1ske3sO=QcrpUbX9QqGyirHnsQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Case insensitive collation  (Marcel van Pinxteren <marcel.van.pinxteren@gmail.com>)
Список pgsql-general
On 21 January 2013 17:25, Marcel van Pinxteren <marcel.van.pinxteren@gmail.com> wrote:
The other reason, is that I assume that "lower()" adds overhead, so makes things slower than they need to be.
Whether that is true, and if that is a compelling reason, I don't know.

Case insensitive collation adds overhead too. It wouldn't surprise me if that were more than lower() adds - collation is complicated stuff.
--
If you can't see the forest for the trees,
Cut the trees and you'll see there is no forest.

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

Предыдущее
От: Marcel van Pinxteren
Дата:
Сообщение: Re: Case insensitive collation
Следующее
От: bhanu udaya
Дата:
Сообщение: Re: pg_Restore