Status : Withdrawn

This standard has been revised by ISO/IEC 19075-1:2021

Abstract

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.

General information

  • Status
     : Withdrawn
    Publication date
     : 2011-07
    Stage
    : Withdrawal of International Standard [95.99]
  • Edition
     : 1
    Number of pages
     : 23
  • Technical Committee :
    ISO/IEC JTC 1/SC 32
    ICS :
    35.060 
  • RSS updates

Life cycle

Sustainable Development Goals

This standard contributes to the following Sustainable Development Goal

9
Industry, Innovation and Infrastructure

Got a question?

Check out our FAQs

Customer care
+41 22 749 08 88

Opening hours:
Monday to Friday - 09:00-12:00, 14:00-17:00 (UTC+1)

  2. Store
  3. Standards catalogue
  4. ICS
  5. 35
  6. 35.060
  7. ISO/IEC TR 19075-1:2011