Re: lower() silently fails for 9.5.3 on Windows, but works on Mac, Linux

Поиск
Список
Период
Сортировка
От Alexander Farber
Тема Re: lower() silently fails for 9.5.3 on Windows, but works on Mac, Linux
Дата
Msg-id CAADeyWjtv_8jJUKVkfoCTf=ncn+AEY6rNP6A1TvEMH_XLy5-dg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: lower() silently fails for 9.5.3 on Windows, but works on Mac, Linux  ("Charles Clavadetscher" <clavadetscher@swisspug.org>)
Ответы Re: lower() silently fails for 9.5.3 on Windows, but works on Mac, Linux
Список pgsql-general
Дерево обсуждения
Hello Charles, unfortunately on Windows 7 this fails:

psql (9.5.3)
Type "help" for help.

# select lower(('И'::text collate "en_US")) ;
ERROR:  collation "en_US" for encoding "UTF8" does not exist
LINE 1: select lower(('?'::text collate "en_US")) ;
                                ^
By the way I the following code works well for me on all 3 platforms:

CREATE TABLE words_verbs (
        word varchar(255) PRIMARY KEY CHECK (
                word ~ '^[А-Я]{2,}$' AND
                word !~ '[ЖШ]Ы' AND
                word !~ '[ЧЩ]Я' AND
                word !~ 'Ц[ЮЯ]' AND
                (word ~ '[ТЧ]ЬСЯ$' OR
                 word ~ '[ТЧ]Ь$' OR 
                 word ~ 'ТИ$')),
        hashed varchar(32) NOT NULL
);

but I understand that it is probably different methods on the lower layer (pcre instead of some collating functions?)....

Regards
Alex

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