Chapter 7: DML statements

Table of Contents

DELETE

COLLATE subclause for text BLOB columns

ORDER BY

PLAN

Relation alias makes real name unavailable

RETURNING

ROWS

EXECUTE BLOCK

COLLATE in variable and parameter declarations

NOT NULL in variable and parameter declarations

Domains instead of data types

TYPE OF COLUMN in parameter and variable declarations

EXECUTE PROCEDURE

INSERT

INSERT ... DEFAULT VALUES

RETURNING clause

UNION allowed in feeding SELECT

MERGE

SELECT

Aggregate functions: Extended functionality

[AS] before relation alias

COLLATE subclause for text BLOB columns

Common Table Expressions (“WITH ... AS ... SELECT”)

Derived tables (“SELECT FROM SELECT”)

FIRST and SKIP

GROUP BY

HAVING: Stricter rules

JOIN

ORDER BY

PLAN

Relation alias makes real name unavailable

ROWS

UNION

WITH LOCK

UPDATE

Changed SET semantics

COLLATE subclause for text BLOB columns

ORDER BY

PLAN

Relation alias makes real name unavailable

RETURNING

ROWS

UPDATE OR INSERT