PD ISO/IEC TR 19075-1:2011 - Page 2

Information technology. Database languages. SQL technical reports. XQuery regular expression support in SQL | Status: Superseded, Withdrawn

1 Scope This Technical Report describes the regular expression support in SQL adopted from the regular expression syntax of [XQuery F&O], which is derived from Perl. This Technical Report 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.