ISO/IEC TR 19075-1:2011
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
Information technology — Database languages — SQL Technical Reports — Part 1: XQuery Regular Expression Support in SQL
Hardcopy , PDF
English
06-07-2011
09-04-2025
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.
| Committee |
ISO/IEC JTC 1/SC 32
|
| DocumentType |
Standard
|
| Pages |
23
|
| PublisherName |
International Organization for Standardization
|
| Status |
Withdrawn
|
| SupersededBy |
| Standards | Relationship |
| PD ISO/IEC TR 19075-1:2011 | Identical |
| NEN NPR ISO/IEC TR 19075-1 : 2011 | Identical |
| INCITS/ISO/IEC TR 19075-1 : 2015 | Identical |
| INCITS/ISO/IEC TR 19075-1:2021 | Identical |
| ISO/IEC 9075-2:2016 | Information technology — Database languages — SQL — Part 2: Foundation (SQL/Foundation) |
| 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 |
Access your standards online with a subscription
-
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.
Important note : Users cannot be edited or removed once added to your Multi user PDF.