Account:  - Login  |  Webstore  |  Shopping basket cart
English  |  Français  |  Nederlands

Publication details

Publication CODE Title
ISO/IEC TR 19075-1:2011 (2011-07) INFORMATION TECHNOLOGY -- DATABASE LANGUAGES -- SQL TECHNICAL REPORTS -- PART 1: XQUERY REGULAR EXPRESSION SUPPORT in SQL
 
Price Excl. VAT Total number of pages, tables and drawings
137.00 € 23.
Description
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.

Class  C990  (IEC PUBLICATIONS IEC PUBLICATIONS)
Available files
EN version

Status
Status IEC PUBLICATION
Situation Currently active
Origin
Committee ISO/IEC JTC 1/SC 32
DATA MANAGEMENT SERVICES
Approval
BEC Approval 2011-07-06
ICS-Code (International Standards Classification) 35.060
NBN Status New
IEC publication date 2011-07-06
IEC last modification date 2014-04-14