INCITS/ISO/IEC TR 19075-1:2011
Information technology - Database languages - SQL Technical Reports - Part 1: XQuery Regular Expression Support in SQL (Technical Report)

Standard No.

INCITS/ISO/IEC TR 19075-1:2011

Release Date

2011

Published By

ANSI - American National Standards Institute

Latest

INCITS/ISO/IEC TR 19075-1:2011

Scope

This Technical Report describes the regular expression support in SQL adopted from the regular expression syntax of [XQuery FO]@ 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.

INCITS/ISO/IEC TR 19075-1:2011 history

• 2011 INCITS/ISO/IEC TR 19075-1:2011 Information technology - Database languages - SQL Technical Reports - Part 1: XQuery Regular Expression Support in SQL (Technical Report)