Re: Case Insensitive Foreign Key Constraint

Поиск
Список
Период
Сортировка
От Peter Geoghegan
Тема Re: Case Insensitive Foreign Key Constraint
Дата
Msg-id AANLkTinxj8YkxFqLnB6LRUzXGzxGHNAtj-N_aHJ3+Q5T@mail.gmail.com
обсуждение исходный текст
Ответ на Case Insensitive Foreign Key Constraint  ("George Weaver" <gweaver@shaw.ca>)
Список pgsql-general
I would probably just have a check constraint that prevented the
relevant PK field from being lower case in the first place. I had to
do that recently, but my approach reflected the business rules.

You may prefer to use citext:

http://www.postgresql.org/docs/current/interactive/citext.html

--
Regards,
Peter Geoghegan

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

Предыдущее
От: "George Weaver"
Дата:
Сообщение: Case Insensitive Foreign Key Constraint
Следующее
От: "James B. Byrne"
Дата:
Сообщение: Getting a sample data set.