Re: force varchar column to be lowercase

Поиск
Список
Период
Сортировка
От Andreas Wenk
Тема Re: force varchar column to be lowercase
Дата
Msg-id 4A6EDCE6.5090102@netzmeister-st-pauli.de
обсуждение исходный текст
Ответ на Re: force varchar column to be lowercase  (Greg Stark <gsstark@mit.edu>)
Список pgsql-admin
Greg Stark schrieb:
> On Tue, Jul 28, 2009 at 11:15 AM, Andreas
> Wenk<a.wenk@netzmeister-st-pauli.de> wrote:
>> Kevin Kempter schrieb:
>>> Can I use a check constraint, or something other than a function to force
>>> a column to be lowercase only?
>>>
>>>
>>> Thx in advance
>> try to use regexp in your CHECK CONSTRAINT:
>>
>> CHECK (column::bpchar ~ '^[a-z]+$'::bpchar::text)
>
> Better would be CHECK (column = tolower(column)) which won't fail on
> non-letters and will work in non-C locales

yes . but Kevin was asking for a way without a function. And by the way - it should read
lower instead of tolower ... or am I wrong?

Cheers

Andy

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

Предыдущее
От: Greg Stark
Дата:
Сообщение: Re: force varchar column to be lowercase
Следующее
От: Greg Spiegelberg
Дата:
Сообщение: Re: WAL backup