1.1. About the Author 1.1.1. Translation…​ 1.1.2. …​ and More Translation 1.1. About the Author Denis Simonov…​ 1.1.1. Translation…​ Development of the original Russian ve...

6.1.4. URL-style connection strings 6.1.4. URL-style connection strings Local URL-style connection strings have already been introduced. A remote URL-style connection string c...

11.1.3. Administrators 11.1.3. Administrators As a general description, an administrator is a user that has sufficient rights to read, write to, create, alter or delete any obj...

6.4.3. Expressions involving NULL The DISTINCT keyword comes to the rescue! More about NULL s 6.4.3. Expressions involving NULL In SQL, NULL is not a value. It is a condi...

2.2.4. Stored Procedures Adding a new invoice Editing an invoice Deleting an invoice Paying an invoice Invoice Line Items Adding line items Editing line items Deleting line i...

3.4 Data Types for Dates and Times 3.4.1 DATE 3.4.2 TIME 3.4.2.1 TIME [WITHOUT TIME ZONE] 3.4.2.2 TIME WITH TIME ZONE 3.4.3 TIMESTAMP 3.4.3.1 TIMESTAMP [WITHOUT TIME ZONE]...

9.16. SQLSTATE 9.16. SQLSTATE Available in PSQL Added in 2.5.1 Type CHAR(5) Description In a “WHEN …​ DO ” error handler, the SQLSTATE context variable contains the ...

8.5 Type Casting Functions 8.5.1 CAST() 8.5.1.1 Shorthand Syntax 8.5.1.2 Allowed Type Conversions 8.5.1.3 Casting Parameters 8.5.1.4 Casting to a Domain or its Type 8.5.1.5 Ca...

8.5. Type Casting Functions 8.5.1. CAST() “Shorthand” Syntax Cast Examples 8.5. Type Casting Functions 8.5.1. CAST() Available in DSQL, ESQL, PSQL Changed in 2.5 Syn...

3.1. Integer Data Types 3.1.1. SMALLINT 3.1.2. INTEGER 3.1.3. BIGINT 3.1.4. Hexadecimal Format for Integer Numbers 3.1. Integer Data Types The SMALLINT , INTEGER and BI...