regexp_match ( string text, pattern text [, flags text ] ) → text[]Returns substrings within the first match of the POSIX regular expression
pattern to the string; see Section 9.7.3.regexp_match('foobarbequebaz', '(bar)(beque)') → {bar,beque}FUNCTIONS / STRING FUNCTIONS AND OPERATORS
regexp_match
Read PG 18 manual ↗Returns substrings within the first match of the POSIX regular expression pattern to the string; see Section 9.7.3.
Signatures & examples
Version history 4
- PG 18 → 19changed
- PG 14 → 15changed
- PG 12 → 13changed
- PG 9.6 → 10added
Definition snapshot: 2026-09-14T13:14:25.684213+00:00@99e6866c · English manual source