SQL Commands / Version comparison
What changed?
SQL Commands · PostgreSQL 6.4 → 6.5
Historical documentation for a PostgreSQL version that is no longer supported.
1 added · 2 removed · 27 changed · 0 coverage changes. These are changes between the pinned reference snapshots.
changedDROP SEQUENCE
--- 6.4 +++ 6.5 @@ -1 +1 @@ -DROP SEQUENCE seqname [, ...] +DROP SEQUENCE name [, ...]
changedCREATE TABLE
--- 6.4 +++ 6.5 @@ -1,7 +1,6 @@ -CREATE TABLE table ( +CREATE [ TEMPORARY | TEMP ] TABLE table ( column type -[ DEFAULT value] -[, NOT NULL ] [ ,UNIQUE ] +[ NULL | NOT NULL ] [ UNIQUE ] [ DEFAULT value ] [column_constraint_clause | PRIMARY KEY } [ ... ] ] [, ... ] [, PRIMARY KEY ( column [, ...] ) ]
changedALTER TABLE
--- 6.4 +++ 6.5 @@ -1,6 +1,6 @@ ALTER TABLE table -[ * ] ADD [ COLUMN ] column type +[ * ] ADD [ COLUMN ] ER">coBLE> type ALTER TABLE table -[ * ] RENAME [ COLUMN ] column TO newcolumn +[ * ] RENAME [ COLUMN ] ER">coBLE> TO newcolumn ALTER TABLE table RENAME TO newtable
changedDROP TABLE
--- 6.4 +++ 6.5 @@ -1 +1 @@ -DROP TABLE table [, ...] +DROP TABLE name [, ...]
removedCREATE TABLE AS
--- 6.4 +++ 6.5 @@ -1 +0,0 @@ -CREATE TABLE table [ ( column [, ...] ) ] AS select_clause
changedDROP VIEW
--- 6.4 +++ 6.5 @@ -1 +1 @@ -DROP VIEW view +DROP VIEW name
changedCREATE INDEX
--- 6.4 +++ 6.5 @@ -3,4 +3,4 @@ ( column [ ops_name] [, ...] ) CREATE [ UNIQUE ] INDEX index_name ON table [ USING acc_name ] -( func_name( column [, ... ]) ops_name ) +( func_name( r">colle> [, ... ]) ops_name )
changedCREATE FUNCTION
--- 6.4 +++ 6.5 @@ -1,4 +1,4 @@ CREATE FUNCTION name ( [ ftype [, ...] ] ) RETURNS rtype -AS path +AS definition LANGUAGE 'langname'
changedDROP LANGUAGE
--- 6.4 +++ 6.5 @@ -1 +1 @@ -DROP PROCEDURAL LANGUAGE 'langname' +DROP PROCEDURAL LANGUAGE 'name'
changedCREATE OPERATOR
--- 6.4 +++ 6.5 @@ -5,7 +5,8 @@ [, COMMUTATOR = com_op ] [, NEGATOR = neg_op ] [, RESTRICT = res_proc ] +[, JOIN = join_proc ] [, HASHES ] -[, JOIN = join_proc ] -[, SORT = sort_op [, ...] ] +[, SORT1 = left_sort_op ] +[, SORT2 = right_sort_op ] )
changedGRANT
--- 6.4
+++ 6.5
@@ -1,3 +1,2 @@
-GRANT privilege [, ...]
-ON object [, ...]
+GRANT privilege [, ...] ON object [, ...]
TO { PUBLIC | GROUP group | username }
changedREVOKE
--- 6.4
+++ 6.5
@@ -1,3 +1,3 @@
REVOKE privilege [, ...]
ON object [, ...]
-FROM { PUBLIC | GROUP group | username }
+FROM { PUBLIC | GROUP ER">gBLE> | username }
changedALTER USER
--- 6.4 +++ 6.5 @@ -1,6 +1,4 @@ -ALTER USER username -[ WITH PASSWORD password ] -[ CREATEDB | NOCREATEDB ] -[ CREATEUSER | NOCREATEUSER ] +ALTER USER username [ WITH PASSWORD password ] +[ CREATEDB | NOCREATEDB ] [ CREATEUSER | NOCREATEUSER ] [ IN GROUP groupname [, ...] ] [ VALID UNTIL 'abstime' ]
changedDROP USER
--- 6.4 +++ 6.5 @@ -1 +1 @@ -DROP USER username +DROP USER name
changedCREATE RULE
--- 6.4 +++ 6.5 @@ -1,4 +1,3 @@ -CREATE RULE name -AS ON event +CREATE RULE name AS ON event TO object [ WHERE condition ] DO [ INSTEAD ] [ action | NOTHING ]
changedCREATE TRIGGER
--- 6.4
+++ 6.5
@@ -1,4 +1,3 @@
-CREATE TRIGGER name { BEFORE | AFTER }
-{ event [OR ...] }
+CREATE TRIGGER name { BEFORE | AFTER } { event [OR ...] }
ON table FOR EACH { ROW | STATEMENT }
-EXECUTE PROCEDURE funcname ( arguments )
+EXECUTE PROCEDURE ER">funcBLE> ( arguments )
changedLOAD
changedCOPY
--- 6.4
+++ 6.5
@@ -1,6 +1,8 @@
COPY [ BINARY ] table [ WITH OIDS ]
-FROM { 'filename' | stdin }
+FROM { 'filename' |
+stdin }
[ USING DELIMITERS 'delimiter' ]
COPY [ BINARY ] table [ WITH OIDS ]
-TO { 'filename' | stdout }
+TO { 'filename' |
+stdout }
[ USING DELIMITERS 'delimiter' ]
changedINSERT
changedLOCK
--- 6.4
+++ 6.5
@@ -1 +1,3 @@
LOCK [ TABLE ] table
+LOCK [ TABLE ] table IN [ ROW | ACCESS ] { SHARE | EXCLUSIVE } MODE
+LOCK [ TABLE ] table IN SHARE ROW EXCLUSIVE MODE
changedSELECT
--- 6.4
+++ 6.5
@@ -1,9 +1,13 @@
SELECT [ALL|DISTINCT [ON column] ]
-expression [ AS name ] [, ...]
-[ INTO [TABLE] new_table ]
-[ FROM table [alias ] [, ...] ]
+expression [ AS
+name ] [, ...]
+[ INTO [TEMP] [TABLE] new_table ]
+[ FROM table
+[alias ] [, ...] ]
[ WHERE condition ]
[ GROUP BY column [, ...] ]
[ HAVING condition [, ...] ]
-[ UNION [ALL] select ]
+[ { UNION [ALL] | INTERSECT | EXCEPT } select ]
[ ORDER BY column [ ASC | DESC ] [, ...] ]
+[ FOR UPDATE [OF class_name...]]
+[ LIMIT count [OFFSET|, count]]
changedSELECT INTO
--- 6.4
+++ 6.5
@@ -1,8 +1,10 @@
SELECT [ ALL | DISTINCT ] expression [ AS name ] [, ...]
-INTO [ TABLE ] new_table ]
+INTO [TEMP] [ TABLE ] new_table ]
[ FROM table [alias] [, ...] ]
[ WHERE condition ]
[ GROUP BY column [, ...] ]
[ HAVING condition [, ...] ]
-[ UNION [ ALL ] select]
+[ { UNION [ALL] | INTERSECT | EXCEPT } select]
[ ORDER BY column [ ASC | DESC ] [, ...] ]
+[ FOR UPDATE [OF class_name...]]
+[ LIMIT count [OFFSET|, count]]
changedFETCH
--- 6.4
+++ 6.5
@@ -1,4 +1,5 @@
-FETCH [ selector ] [ count ]
-{ IN | FROM } cursor
-FETCH [ RELATIVE ] [ { [ # | ALL | NEXT | PRIOR ] } ]
-FROM ] cursor
+FETCH [ selector ] [ count ] { IN | FROM } cursor
+FETCH [ RELATIVE ] [ { [ # | ALL | NEXT | PRIOR ] } ] FROM ] cursor
+
+
+FETCH RELATIVE 0 FROM cursor
changedABORT
--- 6.4 +++ 6.5 @@ -1 +1 @@ -ABORT +ABORT [ TRANSACTION | WORK ]
addedBEGIN
--- 6.4 +++ 6.5 @@ -0,0 +1,2 @@ + +BEGIN [ WORK | TRANSACTION ]
changedROLLBACK
--- 6.4 +++ 6.5 @@ -1 +1 @@ -ROLLBACK [ WORK ] +ROLLBACK [ WORK | TRANSACTION ]
removedBEGIN WORK
--- 6.4 +++ 6.5 @@ -1,2 +0,0 @@ - -BEGIN [ WORK | TRANSACTION ]
changedLISTEN
--- 6.4 +++ 6.5 @@ -1 +1 @@ -LISTEN notifyname +LISTEN name
changedNOTIFY
--- 6.4 +++ 6.5 @@ -1 +1 @@ -NOTIFY notifyname +NOTIFY name
changedSET
--- 6.4
+++ 6.5
@@ -1,2 +1,3 @@
SET variable { TO | = } { 'value' | DEFAULT }
-SET TIME ZONE { 'timezone' | LOCAL };
+SET TIME ZONE { 'timezone' | LOCAL | DEFAULT }
+SET TRANSACTION ISOLATION LEVEL { READ COMMITTED | SERIALIZED }