Replaces the substring that is the first match to the POSIX regular expression pattern, or all such matches if the g flag is used; see Section 9.7.3.
regexp_replace ( string text, pattern text, replacement text [, flags text ] ) → textReplaces the substring that is the first match to the POSIX regular expression
pattern, or all such matches if the g flag is used; see Section 9.7.3.regexp_replace('Thomas', '.[mN]a.', 'M') → ThMregexp_replace ( string text, pattern text, replacement text, start integer [, N integer [, flags text ] ] ) → textReplaces the substring that is the
N'th match to the POSIX regular expression pattern, or all such matches if N is zero, with the search beginning at the start'th character of string. If N is omitted, it defaults to 1. See Section 9.7.3.regexp_replace('Thomas', '.', 'X', 3, 2) → ThoXasregexp_replace(string=>'hello world', pattern=>'l', replacement=>'XX', start=>1, "N"=>2) → helXXo world
Definition snapshot: 2026-09-14T13:14:25.684213+00:00@99e6866c · English manual source