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 по дате отправления: