Firebird 4.0 Language Reference Dmitry Filippov, Alexander Karpeykin, Alexey Kovyazin, Dmitry Kuzmenko, Denis Simonov, Paul Vinkenoog, Dmitry Yemanov, Mark Rotteveel Version 2.10, 15 December 2023 The source of much copied reference material: Paul Vinkenoog Copyright © 2017-2023 Firebird Project and all contributing authors, under the Public Documentation License Version 1.0. Please refer to request with the necessary changes. Preface 1 Table of Contents 1. About the Firebird 4.0 Language Reference . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

Firebird 2.5 Language Reference Dmitry Filippov, Alexander Karpeykin, Alexey Kovyazin, Dmitry Kuzmenko, Denis Simonov, Paul Vinkenoog, Dmitry Yemanov Version 1.16, 15 December 2023 The source of much much copied reference material: Paul Vinkenoog Copyright © 2017-2023 Firebird Project and all contributing authors, under the Public Documentation License Version 1.0. Please refer to the License Notice topics concerning Firebird’s SQL language written by members of the Russian-speaking community of Firebird developers and users. In 2014, it culminated in a language reference manual, in Russian. At the instigation

слова; • Типы и подтипы данных; • Операторы DDL (Data Definition Language — язык создания данных); • Операторы DML (Data Manipulation Language — язык обращения с данными); • Операторы управления транзакциями; org документ доступен по адресу https://www.firebirdsql.org/ file/documentation/reference_manuals/firebird-language-reference-30-rus.pdf Кроме того, данный документ выложен в различных форматах на сайте (I <= 5) DO BEGIN SELECT LANGUAGE_REQ[:I] FROM JOB WHERE (JOB_CODE = :CODE) AND (JOB_GRADE = :GRADE) AND (JOB_COUNTRY = :CTY) AND (LANGUAGE_REQ IS NOT NULL)) INTO :LANGUAGES;

..................................................................................3 2. The SQL Language ............................................................................................... ................................................................................21 II. The SQL Language................................................................................................ ................................................................................474 31.4. Query Language (SQL) Functions ..............................................................................474

..................................................................................3 2. The SQL Language ............................................................................................... ................................................................................19 II. The SQL Language................................................................................................ ................................................................................447 31.4. Query Language (SQL) Functions .......................................................................448 31.4

..................................................................................3 2. The SQL Language ............................................................................................... ................................................................................21 II. The SQL Language................................................................................................ .........................................................................509 xiii 32.4. Query Language (SQL) Functions ..............................................................................509

..................................................................................3 2. The SQL Language ............................................................................................... ................................................................................21 II. The SQL Language................................................................................................ ................................................................................512 32.4. Query Language (SQL) Functions ..............................................................................512

..................................................................................3 2. The SQL Language ............................................................................................... ................................................................................21 II. The SQL Language................................................................................................ ................................................................................580 33.4. Query Language (SQL) Functions ..............................................................................580

..................................................................................3 2. The SQL Language ............................................................................................... ................................................................................21 II. The SQL Language................................................................................................ ................................................................................580 33.4. Query Language (SQL) Functions ..............................................................................580

for Specifying Table Distribution Columns 210 Resource Groups Features 211 PL/pgSQL Procedural Language Enhancements 211 Replicated Table Data 212 Concurrency Improvements in Greenplum 6 212 Additional Installing Optional Extensions (Tanzu Greenplum) 0 Procedural Language, Machine Learning, and Geospatial Extensions 269 Procedural Language, Machine Learning, and Geospatial Extensions 0 Python Data Science Machine Learning and Deep Learning 383 Geospatial Analytics 384 Text Analytics 384 Programming Language Extensions 384 Why Greenplum Database in Integrated Analytics 384 Machine Learning and Deep Learning