ISO/IEC 19075-1
Information technology — Guidance for the use of database language SQL — Part 1: XQuery regular expressions
active, Most Current
| Organization: | ISO |
| Publication Date: | 1 August 2021 |
| Status: | active |
| Page Count: | 34 |
| ICS Code (Languages used in information technology): | 35.060 |
scope:
This document describes the regular expression support in SQL (ISO/IEC 9075-2) adopted from the regular expression syntax of XQuery and XPath Functions and Operators 3.1, which is derived from Perl. This document discusses five operators using this regular expression syntax:
- LIKE_REGEX predicate, to determine the existence of a match to a regular expression.
- OCCURRENCES_REGEX numeric function, to determine the number of matches to a regular expression.
- POSITION_REGEX function, to determine the position of a match.
- SUBSTRING_REGEX function, to extract a substring matching a regular expression.
- TRANSLATE_REGEX function, to perform replacements using a regular expression.
Document History
ISO/IEC 19075-1
August 1, 2021
Information technology — Guidance for the use of database language SQL — Part 1: XQuery regular expressions
This document describes the regular expression support in SQL (ISO/IEC 9075-2) adopted from the regular expression syntax of XQuery and XPath Functions and Operators 3.1, which is derived from Perl....