Distributed transaction Distributed transaction At the time of writing this feature is only supported by PostgreSQL, MySQL and Firebird, since they expose API for two-phase co...

2.6 Comments 2.6 Comments Comments may be present in SQL scripts, SQL statements and PSQL modules. A comment can be any text specified by the code writer, usually used to docume...

6.8 EXECUTE BLOCK 6.8.1 Examples 6.8.2 Input and output parameters 6.8.3 Statement Terminators 6.8 EXECUTE BLOCK Used forCreating an anonymous block of PSQL code in DSQL fo...

6.1.12. WITH LOCK Usage with a FOR UPDATE Clause How the engine deals with WITH LOCK Caveats using WITH LOCK Examples using explicit locking 6.1.12. WITH LOCK Availabl...

D.30 RDB$RELATION_CONSTRAINTS D.30 RDB$RELATION_CONSTRAINTS RDB$RELATION_CONSTRAINTS stores the definitions of all table-level constraints: primary, unique, foreign key, CHEC...

6.4 UPDATE OR INSERT 6.4.1 The RETURNING clause 6.4.2 Example of UPDATE OR INSERT 6.4 UPDATE OR INSERT Used forUpdating an existing record in a table or, if it does not ex...

5.1.4. Appointing co-administrators Differences between co-administrators and SYSDBA 5.1.4. Appointing co-administrators Note: What follows here is not essential knowledge f...

Appendix G: License notice Appendix G: License notice The contents of this Documentation are subject to the Public Documentation License Version 1.0 (the “License”); you may on...

Dialects Included Dialects Included, but not currently supported dialects External Dialects Dialects The dialect is the system SQLAlchemy uses to communicate with various t...

3.4. Data Types for Dates and Times 3.4.1. DATE 3.4.2. TIME 3.4.3. TIMESTAMP 3.4.4. Operations Using Date and Time Values 3.4. Data Types for Dates and Times The DATE , ...