Undocumented behaviour of \s in SIMILAR TO expression

Поиск
Список
Период
Сортировка
От PG Doc comments form
Тема Undocumented behaviour of \s in SIMILAR TO expression
Дата
Msg-id 154470529073.5057.10757027183683688588@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: Undocumented behaviour of \s in SIMILAR TO expression  (Bruce Momjian <bruce@momjian.us>)
Список pgsql-docs
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/11/functions-matching.html
Description:

SELECT ' ' SIMILAR TO '[\s]';
returns true

SELECT ' ' SIMILAR TO '[\q]';
generates an error: [2201B]: ERROR: invalid regular expression: invalid
escape \ sequence

\s is not mentioned in the SIMILAR TO section
(https://www.postgresql.org/docs/current/functions-matching.html#FUNCTIONS-SIMILARTO-REGEXP).
If it’s officially supported (which would be useful for my current task), it
should be documented. Otherwise the server should generate an error like for
other invalid escapes.

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

Предыдущее
От: PG Doc comments form
Дата:
Сообщение: citext plugin is not working with java applications
Следующее
От: PG Doc comments form
Дата:
Сообщение: pgBadger link needs to be updated