Information technology - Guidance for the use of database language SQL - Part 1: XQuery regular expressions

Designation Number:
ISO/IEC 19075-1:2021
Standard Type:
National Standard of Canada - Adoption of International Standard
Standard Development Activity:
New Standard
ICS code(s):
35.060
Status:
Proceeding to development
SDO Comment Period Start Date:
SDO Comment Period End Date:
Posted On:

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.

Project need:

To align Canadian requirements with those of international standards in the ICT subject area (adoption of new standard. This proposed New Standard is being developed at the request of P123 Technical Committee on Information Technology. It will provide the industry with the latest requirements in the field of ICT, including cybersecurity and software. This will meet the strategic needs of the following key interests: a) ensuring that the latest innovative/technology/safety features are available for users,

Note: The information provided above was obtained by the Standards Council of Canada (SCC) and is provided as part of a centralized, transparent notification system for new standards development. The system allows SCC-accredited Standards Development Organizations (SDOs), and members of the public, to be informed of new work in Canadian standards development, and allows SCC-accredited SDOs to identify and resolve potential duplication of standards and effort.

Individual SDOs are responsible for the content and accuracy of the information presented here. The text is presented in the language in which it was provided to SCC.