BUG #5766: regexp \y doesn't work properly when a word starts on ends with a UTF-8 char

Поиск
Список
Период
Сортировка
От Grzegorz Daniluk
Тема BUG #5766: regexp \y doesn't work properly when a word starts on ends with a UTF-8 char
Дата
Msg-id 201011241643.oAOGhhB5083127@wwwmaster.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #5766: regexp \y doesn't work properly when a word starts on ends with a UTF-8 char  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
The following bug has been logged online:

Bug reference:      5766
Logged by:          Grzegorz Daniluk
Email address:      gdaniluk@gmail.com
PostgreSQL version: 9.0.1
Operating system:   Windows 7 64-bit
Description:        regexp \y doesn't work properly when a word starts on
ends with a UTF-8 char
Details:

select regexp_replace('Foo Pasaż Bar', E'\\yPasaż\\y', '');

Above query doesn't replace the word 'Pasaż'. It returns full 'Foo Pasaż
Bar' string, when the correct behavior is to return 'Foo  Bar'.

When the 'ż' is replaced with normal ASCII character like 'z',
regexp_replace works as expected.

My db details:
ENCODING = 'UTF8'
LC_COLLATE = 'Polish_Poland.1250'
LC_CTYPE = 'Polish_Poland.1250'

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

Предыдущее
От: Pavel Golub
Дата:
Сообщение: Re: BUG #5765: pg_dump fail to find upper case table name
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #5766: regexp \y doesn't work properly when a word starts on ends with a UTF-8 char