Re: Case insensitive collation

Поиск
Список
Период
Сортировка
От Marcel van Pinxteren
Тема Re: Case insensitive collation
Дата
Msg-id CAE3e+fM7iiBHwQXaZLaiTzWQw1Ge52r6H7AtQDmDXPiq=mXBbA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Case insensitive collation  (Scott Marlowe <scott.marlowe@gmail.com>)
Ответы Re: Case insensitive collation  (Alban Hertroys <haramrae@gmail.com>)
Re: Case insensitive collation  (Scott Marlowe <scott.marlowe@gmail.com>)
Re: Case insensitive collation  (Thomas Kellerer <spam_eater@gmx.net>)
Список pgsql-general
To be honest, the reason I don't want to use citext and lower(), is me being lazy. If I have to use these features, there is more work for me converting from SQL Server to Postgresql. I have to make more changes to my database, and more to my software.
But, developers are generally lazy, so you could argue that this reason is "compelling". 
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.

Marcel

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

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: Case insensitive collation
Следующее
От: Alban Hertroys
Дата:
Сообщение: Re: Case insensitive collation