From: PG Doc comments form <noreply@postgresql.org>
To: pgsql-docs@lists.postgresql.org
Cc: f2381430@mvrht.com
Subject: Undocumented behaviour of \s in SIMILAR TO expression
Date: Thu, 13 Dec 2018 12:48:10 +0000
Message-ID: <154470529073.5057.10757027183683688588@wrigleys.postgresql.org> (raw)
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: noreply@postgresql.org, pgsql-docs@lists.postgresql.org, f2381430@mvrht.com
Subject: Re: Undocumented behaviour of \s in SIMILAR TO expression
In-Reply-To: <154470529073.5057.10757027183683688588@wrigleys.postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox