IEC > Webstore > Search > Register > Check out > Payment > Order confirmation

Publication detail

Reference ISO/IEC/TR 19075-1 ed1.0 withdrawn corrigendum
> preview
Title Information technology -- Database languages -- SQL Technical Reports -- Part 1: XQuery Regular Expression Support in SQL
Publication date 2011-07-06
Format, price
(Swiss francs)
and language
118.- 23 pages
118.- 129 Kb
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.

Technical Committee JTC 1/SC 32 - Data management and interchange  RSS
ICS Codes
35.060 Languages used in information technology
Replaced by
Work in progress
ProjectStage codeForecast publication date
No project under development--


>> Advanced search

Quick access by ref. number


Your basket is empty
Your country is :
Your TVA is : You must login...


Accepted credit cards:
Prices in CHF (Swiss francs)
Request a pro forma to pay by bank transfer or cheque
Learn how to share your publications with your colleagues, using networking options
Prices in CHF (Swiss francs)
We accept the following credit cards:
To pay by bank transfer: request a pro forma
If you purchase regularly through the IEC Webstore you can open a corporate account

Just Published

>> Published in the last 30 days


  1. IEC 60601-1-2 Ed. 4.0
  2. IEC 61000-4-5 Ed. 3.0
  3. IEC 62366-1 Ed. 1.0
  4. IEC 60529 Ed. 2.2
  5. IEC 61010-1 Ed. 3.0
  6. IEC 60601-1-11 Ed. 2.0
  7. IEC 61000-4-4 Ed. 3.0
  8. IEC 60079-0 Ed. 6.0
  9. IEC 60825-1 Ed. 3.0
  10. IEC 61000-4-2 Ed. 2.0