Skip to main content

ISO/IEC TR 19075-1:2011

Superseded Date published:

Warning: Superseded Standard. This document has been superseded without replacement. You may wish to search for a more up to date equivalent.

Information technology -- Database languages -- SQL Technical Reports -- Part 1: XQuery Regular Expression Support in SQL

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.

Get this standard Prices exclude GST
PDF ( Single user document)
$195.06 NZD
HardCopy
$195.06 NZD
Networkable PDF
Price varies
Preview only close
Prev {{ page }}/ {{ numPages }} Next
Preview only close
Prev {{ page }}/ {{ numPages }} Next
Pages: 23

Keep me up-to-date

Sign up to receive updates when there are changes to this standard

Related Information

Similar Standards

  • AS/NZS 1486:1993

    Information technology - Programming languages - Fortran 90

  • AS/NZS 3968.0:1994

    Information technology - Database languages - SQL - Definition of data structures and basic operations

  • AS/NZS 3968.0:1994 A1

    Information technology - Database languages - SQL - Definition of data structures and basic operations: Amendment 1

  • AS/NZS 3968.3:1998

    Information technology - Database languages - SQL - Call-level interface

Preview only close
Prev {{ page }}/ {{ numPages }} Next
Preview only close
Prev {{ page }}/ {{ numPages }} Next
Pages: 23

ISO/IEC TR 19075-1:2011

Get this standard Prices exclude GST
PDF ( Single user document)
$195.06 NZD
HardCopy
$195.06 NZD
Networkable PDF
Price varies

Request to add this standard to your subscription

ISO/IEC TR 19075-1:2011

Price varies
Online library subscription

Click "Send request for subscription" to request for your Account Administrator to add this standard to your subscripiton.

Cancel