Information technology — Guidance for the use of database language SQL — Part 5: Row pattern recognition
Introduction: This document discusses the syntax and semantics for recognizing patterns in rows of a table, as defined in ISO/IEC 9075-2. The organization of this document is as follows: 1) Clause 1, “Scope”, specifies the scope of this document. 2) Clause 2, “Normative references”, identifies additional standards that, through reference in this document, constitute provisions of this document. 3) Clause 3, “Terms and definitions”, defines the terms and definitions used in this document. 4) Clause 4, “Row pattern recognition: FROM clause”, discusses Feature R010, “Row pattern recognition: FROM clause”. 5) Clause 5, “Expressions in MEASURES and DEFINE”, discussesscalar expression syntax in row pattern matching. 6) Clause 6, “Row pattern recognition: WINDOW clause”, discusses Feature R020, “Row pattern recog- nition: WINDOW clause”. Clause 6, “Row pattern recognition: WINDOW clause”, does not duplicate material already presented in Clause 4, “Row pattern recognition: FROM clause” and Clause 5, “Expressions in MEASURES and DEFINE”, which should be read even if the reader is only interested in Feature R020, “Row pattern recognition: WINDOW clause”. 7) Clause 7, “Pattern matching rules”, discusses the formal rules of pattern matching. © ISO/IEC 2021 – All rights reserved ISO/IEC 19075-5:2021(E)
Scope: This document discusses the syntax and semantics for recognizing patterns in rows of a table, as defined in ISO/IEC 9075-2, commonly called “SQL/RPR”. SQL/RPR defines two features regarding row pattern recognition: Feature R010, “Row pattern recognition: FROM clause” Feature R020, “Row pattern recognition: WINDOW clause” These two features have considerable syntax and semantics in common, the principle difference being whether the syntax is placed in the FROM clause or in the WINDOW clause. © ISO/IEC 2021 – All rights reserved