{"capability":{"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"]},"observed":true,"selected_cell":{"Version":"18","State":"yes","EvidenceKind":"yaml-transition","TransitionVersion":"15","Supported":true,"Original":"Yes"},"selected_version":"18"}