regexp_count ( string text, pattern text [, start integer [, flags text ] ] ) → integerReturns the number of times the POSIX regular expression
pattern matches in the string; see Section 9.7.3.regexp_count('123456789012', '\d\d\d', 2) → 3FUNCTIONS / STRING FUNCTIONS AND OPERATORS
regexp_count
Read PG 18 manual ↗Returns the number of times the POSIX regular expression pattern matches in the string; see Section 9.7.3.
Signatures & examples
Version history 2
- PG 18 → 19changed
- PG 14 → 15added
Definition snapshot: 2026-09-14T13:14:25.684213+00:00@99e6866c · English manual source