Re: Use of !~* to keep a varchar column UNIQUE case-insensitive

Поиск
Список
Период
Сортировка
Искать
От
Don Morrison
Тема
Re: Use of !~* to keep a varchar column UNIQUE case-insensitive
Дата
Msg-id
aee6519f0608181104g5089dceq5bdb1856261a5430@mail.gmail.com
Ответ на
Re: Use of !~* to keep a varchar column UNIQUE case-insensitive (Don Morrison)
Список
Дерево обсуждения
Use of !~* to keep a varchar column UNIQUE case-insensitive "Don Morrison" <donmorrison@gmail.com>
Re: Use of !~* to keep a varchar column UNIQUE case-insensitive Tom Lane <tgl@sss.pgh.pa.us>
Re: Use of !~* to keep a varchar column UNIQUE case-insensitive "Don Morrison" <donmorrison@gmail.com>
Re: Use of !~* to keep a varchar column UNIQUE case-insensitive Tom Lane <tgl@sss.pgh.pa.us>
Re: Use of !~* to keep a varchar column UNIQUE case-insensitive "Don Morrison" <donmorrison@gmail.com>
Re: Use of !~* to keep a varchar column UNIQUE "Daniel T. Staal" <DStaal@usa.net>
Re: Use of !~* to keep a varchar column UNIQUE "Don Morrison" <donmorrison@gmail.com>
Re: Use of !~* to keep a varchar column UNIQUE case-insensitive "Don Morrison" <donmorrison@gmail.com>
Re: Use of !~* to keep a varchar column UNIQUE Sean Davis <sdavis2@mail.nih.gov>
Re: Use of !~* to keep a varchar column UNIQUE case-insensitive "Don Morrison" <donmorrison@gmail.com> 
> create unique index fooi on foo (lower(trim both
> '\040\f\t\r\n\a\b\e\v' from name));

Whoops, I had to shorten that to '\040\f\t\r\n\b'...I was borrowing
from regular expressions again. >:)
В списке pgsql-novice по дате отправления
Предыдущее
От: Don Morrison
Дата:
Следующее
От: Daniel T. Staal
Дата:
FAQ