regexp_count, regexp_instr, regexp_like
Recorded source states and original language descriptions. Missing version evidence stays unknown.
The source snapshot records transitions for PostgreSQL 8.1–18. The historical matrix records independent cells for 7.4–18. Neither records support for PostgreSQL 19 or 20; newer versions remain unknown. These source claims are distinct from runtime measurements.
SQL
Description
regexp_count: counts the number of places that match the regular expression in a stringregexp_instr: returns the starting of the Nth match of a regular expression in a stingregexp_like: returns true if a regular expression has a match in a string.
https://www.postgresql.org/docs/15/functions-matching.html#FUNCTIONS-POSIX-REGEXP
Selected version: PostgreSQL 18
Yes
Compare versions
Original documentation links
Recorded legacy identifiers: 367
Complete source facts and provenance
yaml · center · 1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd
{
"Key": "regexp_count-regexp_instr-regexp_like",
"SourceKind": "yaml",
"SourceDatabase": "center",
"SourceTable": "featurematrix.yaml",
"SourceKey": "regexp_count, regexp_instr, regexp_like",
"SourceHash": "1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd",
"Name": "regexp_count, regexp_instr, regexp_like",
"NameLocale": "en",
"GroupKey": "sql",
"GroupName": "SQL",
"GroupLocale": "en",
"Ordinal": 12,
"GroupOrder": 3,
"Facts": {
"feature": {
"description": "- `regexp_count`: counts the number of places that match the regular expression in a string\r\n- `regexp_instr `: returns the starting of the Nth match of a regular expression in a sting\r\n- `regexp_like`: returns true if a regular expression has a match in a string.\r\n\r\n[https://www.postgresql.org/docs/15/functions-matching.html#FUNCTIONS-POSIX-REGEXP](https://www.postgresql.org/docs/15/functions-matching.html#FUNCTIONS-POSIX-REGEXP)",
"name": "regexp_count, regexp_instr, regexp_like",
"versions": {
"15": "Yes"
}
},
"group": "SQL",
"versions": {
"max": 18,
"min": 8.1
}
},
"Cells": [
{
"Version": "10",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "11",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "12",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "13",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "14",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "15",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "15",
"Supported": true,
"Original": "Yes"
},
{
"Version": "16",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "15",
"Supported": true,
"Original": "Yes"
},
{
"Version": "17",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "15",
"Supported": true,
"Original": "Yes"
},
{
"Version": "18",
"State": "yes",
"EvidenceKind": "yaml-transition",
"TransitionVersion": "15",
"Supported": true,
"Original": "Yes"
},
{
"Version": "8.1",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "8.2",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "8.3",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "8.4",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "9.0",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "9.1",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "9.2",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "9.3",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "9.4",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "9.5",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
},
{
"Version": "9.6",
"State": "no",
"EvidenceKind": "yaml-default-no",
"TransitionVersion": "",
"Supported": false,
"Original": "No"
}
],
"Texts": [
{
"Locale": "en",
"Title": "regexp_count, regexp_instr, regexp_like",
"BodyHTML": "\u003cul\u003e\n\u003cli\u003e\u003ccode\u003eregexp_count\u003c/code\u003e: counts the number of places that match the regular expression in a string\u003c/li\u003e\n\u003cli\u003e\u003ccode\u003eregexp_instr \u003c/code\u003e: returns the starting of the Nth match of a regular expression in a sting\u003c/li\u003e\n\u003cli\u003e\u003ccode\u003eregexp_like\u003c/code\u003e: returns true if a regular expression has a match in a string.\u003c/li\u003e\n\u003c/ul\u003e\n\u003cp\u003e\u003ca href=\"https://www.postgresql.org/docs/15/functions-matching.html#FUNCTIONS-POSIX-REGEXP\" rel=\"nofollow\"\u003ehttps://www.postgresql.org/docs/15/functions-matching.html#FUNCTIONS-POSIX-REGEXP\u003c/a\u003e\u003c/p\u003e\n",
"SourceHash": "1dd22bf9a7f3ec325b894e2836fda535a25529f246a94dd41d6abbfe9997f7fd",
"ContentHash": "07d52c4cb9e6efbbf1520c504c6f50e3bab9e67688c23f2a5cb38c80c1ef7514",
"Payload": {
"description": "- `regexp_count`: counts the number of places that match the regular expression in a string\r\n- `regexp_instr `: returns the starting of the Nth match of a regular expression in a sting\r\n- `regexp_like`: returns true if a regular expression has a match in a string.\r\n\r\n[https://www.postgresql.org/docs/15/functions-matching.html#FUNCTIONS-POSIX-REGEXP](https://www.postgresql.org/docs/15/functions-matching.html#FUNCTIONS-POSIX-REGEXP)",
"name": "regexp_count, regexp_instr, regexp_like",
"versions": {
"15": "Yes"
}
}
},
{
"Locale": "zh-Hans",
"Title": "`regexp_count` / `regexp_instr` / `regexp_like`",
"BodyHTML": "\u003cp\u003e新增 \u003ccode\u003eregexp_count\u003c/code\u003e、\u003ccode\u003eregexp_instr\u003c/code\u003e 和 \u003ccode\u003eregexp_like\u003c/code\u003e，分别用于统计匹配次数、返回第 N 次匹配的位置，以及判断字符串是否匹配正则表达式。\u003c/p\u003e\n",
"SourceHash": "071091951021357a5f492adb04caed6febf4d315ac2626ca027a48dd8ec01d50",
"ContentHash": "f441cb5f85343fd3219304828df57a7b7dce206f6ff5f5f6b64bda77ee4f754a",
"Payload": {
"description": "新增 `regexp_count`、`regexp_instr` 和 `regexp_like`，分别用于统计匹配次数、返回第 N 次匹配的位置，以及判断字符串是否匹配正则表达式。",
"name": "`regexp_count` / `regexp_instr` / `regexp_like`"
}
}
],
"GroupTitles": {
"en": "SQL",
"zh-Hans": "SQL"
},
"LegacyIDs": [
"367"
]
}