Information technology — Guidance for the use of database language SQL — Part 7: Polymorphic table functions
Introduction: 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, “Introduction to polymorphic table functions”, provides an introduction to polymorphic table functions, the requirements leading to their incorporation into SQL, and illustrations of their use. 5) Clause 5, “PTF processing model”, describes the abstract processing model for polymorphic table functions in the context of an SQL-implementation. 6) Clause 6, “Specification”, describes the manner in which polymorphic table functions are specified in the SQL standard. 7) Clause 7, “Data definition language”, provides the syntax and semantics of the SQL statements that create, modify, and drop polymorphic table functions. 8) Clause 8, “Implementation”, guides authors of polymorphictable functions through the steps required to create all of the functions necessary to accomplish particular purposes. 9) Clause 9, “Invocation”, supplies the information necessary for application writers, especially SQL query authors, to take advantage of the polymorphic table functions that are available to them. 10) Clause10, “Compilation”, is directed at the authorsof polymorphictable functionsand of SQL database systems to guide them in the
Scope: This document describes the definition and use of polymorphic table functions in SQL. The Report discusses the following features of the SQL Language: The processing model of polymorphic table functions in the context of SQL. The creation and maintenance of polymorphic table functions. Issues related to methods of implementing polymorphic table functions. How polymorphic table functions are invoked by application programs. Issues concerning compilation, optimization, and execution of polymorphic table functions. © ISO/IEC 2021 – All rights reserved