doc regexp_replace replacement string \n does not explained properly

From: jian he <jian(dot)universality(at)gmail(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: doc regexp_replace replacement string \n does not explained properly
Date: 2024-05-21 03:24:07
Message-ID: CACJufxE5Jp35TSy+Cq+q77ohf1rae0+FrqfMQehJRc2vQM0fWg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

hi.

https://www.postgresql.org/docs/current/functions-matching.html#FUNCTIONS-POSIX-REGEXP
<<<start_quote
The regexp_replace function provides substitution of new text for
substrings that match POSIX regular expression patterns. It has the
syntax regexp_replace(source, pattern, replacement [, start [, N ]] [,
flags ]). (Notice that N cannot be specified unless start is, but
flags can be given in any case.) The source string is returned
unchanged if there is no match to the pattern. If there is a match,
the source string is returned with the replacement string substituted
for the matching substring. The replacement string can contain \n,
where n is 1 through 9, to indicate that the source substring matching
the n'th parenthesized subexpression of the pattern should be
inserted, and it can contain \& to indicate that the substring
matching the entire pattern should be inserted.
<<<end_quote

<<
The replacement string can contain \n, where n is 1 through 9,
to indicate that the source substring matching the n'th parenthesized
subexpression of the pattern should be inserted
<<
i think it explained example like:
SELECT regexp_replace('foobarbaz', 'b(..)', 'X\1Y', 'g');

but it does not seem to explain cases like:
SELECT regexp_replace('foobarbaz', 'b(..)', 'X\2Y', 'g');
?

I think it means that 'b(..)', (..) the parenthesized subexpression is
1, the whole expression is (n+1) parenthesized subexpression.
so it is equivalent to
SELECT regexp_replace('foobarbaz', 'b..', 'XY', 'g');

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message David G. Johnston 2024-05-21 03:44:04 Re: doc regexp_replace replacement string \n does not explained properly
Previous Message Alexander Lakhin 2024-05-21 03:00:00 Re: Cleaning up perl code