Standard

ISO/IEC TR 19075-1:2011

Jul 2011 Withdrawn

Note: This standard has a new edition: ISO/IEC TR 19075-1:2011

Corrigendums and amendments are bought separately.

Language English

Services Read online + Print/Download €77.00 Read online €63.00 Printed and bound Delivery time: 5-10 days €77.00

There are no extended editions available for this standard

There are no available corrigendum or amendments for this standard. Any future corrigendum and amendments will be added automatically for subscribers.

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.

Document information

Standard from ISO/IEC
Published: 6 July 2011
Withdrawn: 31 August 2021
Expires: 10 October 2010
Edition: 1
Document type: TR
Pages
ISBN:

Publisher ISO/IEC
Distributor ISO/IEC
ICS 35.060
ISO TC ISO/IEC JTC 1/SC 32

Product Relations

Revised by: ISO/IEC 19075-1:2021
Revised by: ISO/IEC 19075-1:2021
Revised by: ISO/IEC 19075-1:2021
Joinded work item: ISO/IEC TR 19075-1:2011

ISO/IEC TR 19075-1:2011

Create subscription

Benefits of a subscription: