BUG #5780: Case insensitive regular expressions

Поиск
Список
Период
Сортировка
От Thomas Bakketun
Тема BUG #5780: Case insensitive regular expressions
Дата
Msg-id 201012011727.oB1HRgWY095398@wwwmaster.postgresql.org
обсуждение исходный текст
Список pgsql-bugs
The following bug has been logged online:

Bug reference:      5780
Logged by:          Thomas Bakketun
Email address:      thomasb@copyleft.no
PostgreSQL version: 8.4.5
Operating system:   Ubuntu 10.04.1 LTS
Description:        Case insensitive regular expressions
Details:

Apparently case insensitivity in regular expressions only works for ASCII
characters.

ksys@nallemaja:~$ psql -l
                                  List of databases
   Name    |  Owner   | Encoding |  Collation  |    Ctype    |   Access
privileges
-----------+----------+----------+-------------+-------------+--------------
---------
 ksys      | ksys     | UTF8     | nb_NO.UTF-8 | nb_NO.UTF-8 |
 postgres  | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 |
 s2ksys    | ksys     | UTF8     | nb_NO.UTF-8 | nb_NO.UTF-8 |
 template0 | postgres | UTF8     | en_US.UTF-8 | en_US.UTF-8 | =c/postgres
                                                             :
postgres=CTc/postgres
 template1 | postgres | UTF8     | nb_NO.UTF-8 | nb_NO.UTF-8 |
 template2 | postgres | UTF8     | nb_NO.UTF-8 | nb_NO.UTF-8 |
 test1     | ksys     | UTF8     | nb_NO.UTF-8 | nb_NO.UTF-8 |
(7 rows)

ksys@nallemaja:~$ psql ksys
psql (8.4.5)
Type "help" for help.

ksys=> select 'Øst' ilike 'øst', 'Øst' ~* 'øst';
 ?column? | ?column?
----------+----------
 t        | f
(1 row)

The different behavior of ilike and case insensitive regular expressions is
surprising. I would have expected both to return true. The documentation
makes it clear ilike depends on the current locale, but not so regarding
regular expressions.

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

Предыдущее
От: "Michel Alexandre Salim"
Дата:
Сообщение: BUG #5779: Large INSERT transaction with FOREIGN KEY constraints exhausts available RAM
Следующее
От: "Grant Hutchins and Peter Jaros"
Дата:
Сообщение: BUG #5781: unaccent() function should be marked IMMUTABLE