Case insensitive unique constraint

Поиск
Список
Период
Сортировка
От Rob Brenart
Тема Case insensitive unique constraint
Дата
Msg-id 42D610C8.3040409@oculardata.com
обсуждение
Ответ на Re: To Postgres or not  ("Jim C. Nasby" <decibel@decibel.org>)
Ответы Re: Case insensitive unique constraint
Re: Case insensitive unique constraint
Re: Case insensitive unique constraint
Re: Case insensitive unique constraint
Список pgsql-general
I have a simple table to store account names... I want each name to be
unique in a case insensitive manner... but I want the case the user
enters to be remembered so I can't do a simple lower() on the data's way in.

Is there an easy way to go about this? Am I about to write my first
server side function for postgresql?



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