What changed?

--- 7.0
+++ 7.1
@@ -1,9 +1,22 @@
-CREATE [ TEMPORARY | TEMP ] TABLE table (
-column type
-[ NULL | NOT NULL ] [ UNIQUE ] [ DEFAULT value ]
-[column_constraint_clause | PRIMARY KEY } [ ... ] ]
-[, ... ]
-[, PRIMARY KEY ( column [, ...] ) ]
-[, CHECK ( condition ) ]
-[, table_constraint_clause ]
-) [ INHERITS ( inherited_table [, ...] ) ]
+CREATE [ TEMPORARY | TEMP ] TABLE table_name (
+{ column_name type [ column_constraint [ ... ] ]
+| table_constraint } [, ... ]
+) [ INHERITS ( parent_table [, ... ] ) ]
+
+where column_constraint can be:
+[ CONSTRAINT constraint_name ]
+{ NOT NULL | NULL | UNIQUE | PRIMARY KEY | DEFAULT value | CHECK (condition) |
+REFERENCES table [ ( column ) ] [ MATCH FULL | MATCH PARTIAL ]
+[ ON DELETE action ] [ ON UPDATE action ]
+[ DEFERRABLE | NOT DEFERRABLE ] [ INITIALLY DEFERRED | INITIALLY IMMEDIATE ]
+}
+
+and table_constraint can be:
+[ CONSTRAINT constraint_name ]
+{ UNIQUE ( column_name [, ... ] ) |
+PRIMARY KEY ( column_name [, ... ] ) |
+CHECK ( condition ) |
+FOREIGN KEY ( column_name [, ... ] ) REFERENCES table [ ( column [, ... ] ) ]
+[ MATCH FULL | MATCH PARTIAL ] [ ON DELETE action ] [ ON UPDATE action ]
+[ DEFERRABLE | NOT DEFERRABLE ] [ INITIALLY DEFERRED | INITIALLY IMMEDIATE ]
+}

--- 7.0
+++ 7.1
@@ -1,6 +1,6 @@
-ALTER TABLE table [ * ]
+ALTER TABLE [ ONLY ] table [ * ]
 ADD [ COLUMN ] column type
-ALTER TABLE table [ * ]
+ALTER TABLE [ ONLY ] table [ * ]
 ALTER [ COLUMN ] column { SET DEFAULT value | DROP DEFAULT }
 ALTER TABLE table [ * ]
 RENAME [ COLUMN ] column TO newcolumn
@@ -8,3 +8,5 @@
 RENAME TO newtable
 ALTER TABLE table
 ADD table constraint definition
+ALTER TABLE table
+OWNER TO new owner

--- 7.0
+++ 7.1
@@ -1,2 +1,2 @@
-CREATE TABLE table [ (column [, ...] ) ]
+CREATE [ TEMPORARY | TEMP ] TABLE table [ (column [, ...] ) ]
 AS select_clause

--- 7.0
+++ 7.1
@@ -1 +1 @@
-DROP VIEW name
+DROP VIEW name [, ...]

--- 7.0
+++ 7.1
@@ -1 +1 @@
-DROP INDEX index_name
+DROP INDEX index_name [, ...]

--- 7.0
+++ 7.1
@@ -1,6 +1,4 @@
-CREATE AGGREGATE name ( BASETYPE = input_data_type
-[ , SFUNC1 = sfunc1, STYPE1 = state1_type ]
-[ , SFUNC2 = sfunc2, STYPE2 = state2_type ]
+CREATE AGGREGATE name ( BASETYPE = input_data_type,
+SFUNC = sfunc, STYPE = state_type
 [ , FINALFUNC = ffunc ]
-[ , INITCOND1 = initial_condition1 ]
-[ , INITCOND2 = initial_condition2 ] )
+[ , INITCOND = initial_condition ] )

--- 7.0
+++ 7.1
@@ -6,5 +6,5 @@
 CREATE FUNCTION name ( [ ftype [, ...] ] )
 RETURNS rtype
 AS obj_file , link_symbol
-LANGUAGE 'C'
+LANGUAGE 'langname'
 [ WITH ( attribute [, ...] ) ]

--- 7.0
+++ 7.1
@@ -1,3 +1,3 @@
-CREATE [ TRUSTED ] PROCEDURAL LANGUAGE 'langname'
+CREATE [ TRUSTED ] [ PROCEDURAL ] LANGUAGE 'langname'
 HANDLER call_handler
 LANCOMPILER 'comment'

--- 7.0
+++ 7.1
@@ -1 +1 @@
-DROP PROCEDURAL LANGUAGE 'name'
+DROP [ PROCEDURAL ] LANGUAGE 'name'

--- 7.0
+++ 7.1
@@ -1 +1 @@
-DROP OPERATOR id ( type | NONE [,...] )
+DROP OPERATOR id ( lefttype | NONE , righttype | NONE )

--- 7.0
+++ 7.1
@@ -1,6 +1,10 @@
 CREATE TYPE typename ( INPUT = input_function, OUTPUT = output_function
-, INTERNALLENGTH = { internallength | VARIABLE } [ , EXTERNALLENGTH = { externallength | VARIABLE } ]
+, INTERNALLENGTH = { internallength | VARIABLE }
+[ , EXTERNALLENGTH = { externallength | VARIABLE } ]
 [ , DEFAULT = "default" ]
 [ , ELEMENT = element ] [ , DELIMITER = delimiter ]
 [ , SEND = send_function ] [ , RECEIVE = receive_function ]
-[ , PASSEDBYVALUE ] )
+[ , PASSEDBYVALUE ]
+[ , ALIGNMENT = alignment ]
+[ , STORAGE = storage ]
+)

--- 7.0
+++ 7.1
@@ -1 +1 @@
-DROP TYPE typename
+DROP TYPE typename [, ...]

--- 7.0
+++ 7.1
@@ -1 +1,4 @@
-CREATE DATABASE name [ WITH LOCATION = 'dbpath' ]
+CREATE DATABASE name
+[ WITH [ LOCATION = 'dbpath' ]
+[ TEMPLATE = template ]
+[ ENCODING = encoding ] ]

--- 7.0
+++ 7.1
@@ -1,3 +1,13 @@
 CREATE RULE name AS ON event
 TO object [ WHERE condition ]
-DO [ INSTEAD ] [ action | NOTHING ]
+DO [ INSTEAD ] action
+
+where action can be:
+
+NOTHING
+|
+query
+|
+( query ; query ... )
+|
+[ query ; query ... ]

--- 7.0
+++ 7.1
@@ -1 +1 @@
-DROP RULE name
+DROP RULE name [, ...]

--- 7.0
+++ 7.1
@@ -1 +1 @@
-DELETE FROM table [ WHERE condition ]
+DELETE FROM [ ONLY ] table [ WHERE condition ]

--- 7.0
+++ 7.1
@@ -1,2 +1,2 @@
 INSERT INTO table [ ( column [, ...] ) ]
-{ VALUES ( expression [, ...] ) | SELECT query }
+{ DEFAULT VALUES | VALUES ( expression [, ...] ) | SELECT query }

--- 7.0
+++ 7.1
@@ -1,11 +1,21 @@
 SELECT [ ALL | DISTINCT [ ON ( expression [, ...] ) ] ]
-expression [ AS name ] [, ...]
-[ INTO [ TEMPORARY | TEMP ] [ TABLE ] new_table ]
-[ FROM table [ alias ] [, ...] ]
+* | expression [ AS output_name ] [, ...]
+[ FROM from_item [, ...] ]
 [ WHERE condition ]
-[ GROUP BY column [, ...] ]
+[ GROUP BY expression [, ...] ]
 [ HAVING condition [, ...] ]
-[ { UNION [ ALL ] | INTERSECT | EXCEPT } select ]
-[ ORDER BY column [ ASC | DESC | USING operator ] [, ...] ]
-[ FOR UPDATE [ OF class_name [, ...] ] ]
-LIMIT { count | ALL } [ { OFFSET | , } start ]
+[ { UNION | INTERSECT | EXCEPT [ ALL ] } select ]
+[ ORDER BY expression [ ASC | DESC | USING operator ] [, ...] ]
+[ FOR UPDATE [ OF tablename [, ...] ] ]
+[ LIMIT { count | ALL } [ { OFFSET | , } start ]]
+
+where from_item can be:
+
+[ ONLY ] table_name [ * ]
+[ [ AS ] alias [ ( column_alias_list ) ] ]
+|
+( select )
+[ AS ] alias [ ( column_alias_list ) ]
+|
+from_item [ NATURAL ] join_type from_item
+[ ON join_condition | USING ( join_column_list ) ]

--- 7.0
+++ 7.1
@@ -1,3 +1,3 @@
-UPDATE table SET col = expression [, ...]
+UPDATE [ ONLY ] table SET col = expression [, ...]
 [ FROM fromlist ]
 [ WHERE condition ]

--- 7.0
+++ 7.1
@@ -1,11 +1,22 @@
 SELECT [ ALL | DISTINCT [ ON ( expression [, ...] ) ] ]
-expression [ AS name ] [, ...]
-[ INTO [ TEMPORARY | TEMP ] [ TABLE ] new_table ]
-[ FROM table [ alias ] [, ...] ]
+* | expression [ AS output_name ] [, ...]
+INTO [ TEMPORARY | TEMP ] [ TABLE ] new_table
+[ FROM from_item [, ...] ]
 [ WHERE condition ]
-[ GROUP BY column [, ...] ]
+[ GROUP BY expression [, ...] ]
 [ HAVING condition [, ...] ]
-[ { UNION [ ALL ] | INTERSECT | EXCEPT } select ]
-[ ORDER BY column [ ASC | DESC | USING operator ] [, ...] ]
-[ FOR UPDATE [ OF class_name [, ...] ] ]
-LIMIT { count | ALL } [ { OFFSET | , } start ]
+[ { UNION | INTERSECT | EXCEPT [ ALL ] } select ]
+[ ORDER BY expression [ ASC | DESC | USING operator ] [, ...] ]
+[ FOR UPDATE [ OF tablename [, ...] ] ]
+[ LIMIT { count | ALL } [ { OFFSET | , } start ]]
+
+where from_item can be:
+
+[ ONLY ] table_name [ * ]
+[ [ AS ] alias [ ( column_alias_list ) ] ]
+|
+( select )
+[ AS ] alias [ ( column_alias_list ) ]
+|
+from_item [ NATURAL ] join_type from_item
+[ ON join_condition | USING ( join_column_list ) ]

--- 7.0
+++ 7.1
@@ -1,5 +1,5 @@
-FETCH [ selector ] [ count ] { IN | FROM } cursor
-FETCH [ RELATIVE ] [ { [ # | ALL | NEXT | PRIOR ] } ] FROM ] cursor
+FETCH [ direction ] [ count ] { IN | FROM } cursor
+FETCH [ FORWARD | BACKWARD | RELATIVE ] [ # | ALL | NEXT | PRIOR ] { IN | FROM } cursor
 
 
-FETCH RELATIVE 0 FROM cursor
+FETCH RELATIVE 0 FROM cursor.

--- 7.0
+++ 7.1
@@ -1,2 +1,2 @@
-MOVE [ selector ] [ count ]
+MOVE [ direction ] [ count ]
 { IN | FROM } cursor

--- 7.0
+++ 7.1
@@ -0,0 +1 @@
+SET CONSTRAINTS { ALL | constraint [, ...] } { DEFERRED | IMMEDIATE }

--- 7.0
+++ 7.1
@@ -0,0 +1,2 @@
+SET TRANSACTION ISOLATION LEVEL { READ COMMITTED | SERIALIZABLE }
+SET SESSION CHARACTERISTICS AS TRANSACTION ISOLATION LEVEL { READ COMMITTED | SERIALIZABLE }

--- 7.0
+++ 7.1
@@ -1,4 +1,2 @@
 SET variable { TO | = } { value | 'value' | DEFAULT }
-SET CONSTRAINTS {ALL | constraintlist} mode
 SET TIME ZONE { 'timezone' | LOCAL | DEFAULT }
-SET TRANSACTION ISOLATION LEVEL { READ COMMITTED | SERIALIZABLE }

--- 7.0
+++ 7.1
@@ -1 +1 @@
-SHOW keyword
+SHOW name

--- 7.0
+++ 7.1
@@ -0,0 +1 @@
+CHECKPOINT

--- 7.0
+++ 7.1
@@ -1 +1 @@
-CLUSTER indexname ON table
+CLUSTER indexname ON tablename