• There are no items in your cart

ISO/IEC TR 19075-1:2011

Withdrawn
Withdrawn

A Withdrawn Standard is one, which is removed from sale, and its unique number can no longer be used. The Standard can be withdrawn and not replaced, or it can be withdrawn and replaced by a Standard with a different number.

View Superseded by
withdrawn

A Withdrawn Standard is one, which is removed from sale, and its unique number can no longer be used. The Standard can be withdrawn and not replaced, or it can be withdrawn and replaced by a Standard with a different number.

Information technology Database languages SQL Technical Reports Part 1: XQuery Regular Expression Support in SQL
Available format(s)

Hardcopy , PDF , PDF 3 Users , PDF 5 Users , PDF 9 Users

Withdrawn date

08-31-2021

Language(s)

English

Published date

07-06-2011

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.

DocumentType
Standard
Pages
23
PublisherName
International Organization for Standardization
Status
Withdrawn
SupersededBy

ISO/IEC 9075-2:2016 Information technology — Database languages — SQL — Part 2: Foundation (SQL/Foundation)
CAN/CSA-ISO/IEC 9075-2:18 Information technology - Database languages - SQL - Part 2: Foundation (SQL/Foundation) (Adopted ISO/IEC 9075-2:2016, fifth edition, 2016-12-15)

ISO/IEC 9075-2:2016 Information technology — Database languages — SQL — Part 2: Foundation (SQL/Foundation)
ISO/IEC 9075-14:2016 Information technology — Database languages — SQL — Part 14: XML-Related Specifications (SQL/XML)
IEEE/Open Group 1003.1, 2013 Edition IEEE Standard for Information Technology—Portable Operating System Interface (POSIX(TM)) Base Specifications, Issue 7

View more information
US$73.00
Excluding Tax where applicable

Access your standards online with a subscription

Features

  • Simple online access to standards, technical information and regulations.

  • Critical updates of standards and customisable alerts and notifications.

  • Multi-user online standards collection: secure, flexible and cost effective.