ISO/IEC-19075-1 › Historical Revision Information
Information technology - Database languages - SQL Technical Reports - Part 1: XQuery Regular Expression Support in SQL

ISO/IEC-19075-1 - 2011 EDITION - SUPERSEDED
Show Complete Document History

Document Center Inc. is an authorized dealer of ISO standards.
The following bibliographic material is provided to assist you with your purchasing decision:


ISO/IEC TR 19075-1:2011 describes the regular expression support in SQL adopted from the regular expression syntax of XQuery 1.0 and XPath 2.0 Functions and Operators (Second Edition), which is derived from Perl. It 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.
ORDER

To find similar documents by classification:

35.060 (Languages used in information technology)

This document comes with our free Notification Service, good for the life of the document.

This document is available in either Paper or PDF format.

Document Number

ISO/IEC TR 19075-1:2011

Revision Level

2011 EDITION

Status

Superseded

Publication Date

July 15, 2011

Committee Number

ISO/IEC/JTC 1/SC 32