as per SQL:2003 Annex E pp.1173-1175 "Incompatibilities with SQL:1999",
specifically point 17, pp.1174-1175:

"A number of additional <reserved word>s have been added to the
language".

Enjoy.

-- 
Best Regards, Simon Riggs
Index: keywords.c
===================================================================
RCS file: /projects/cvsroot/pgsql/src/backend/parser/keywords.c,v
retrieving revision 1.153
diff -d -c -r1.153 keywords.c
*** keywords.c	29 Aug 2004 04:12:40 -0000	1.153
--- keywords.c	23 Nov 2004 22:46:48 -0000
***************
*** 50,55 ****
--- 50,56 ----
  	{"assertion", ASSERTION},
  	{"assignment", ASSIGNMENT},
  	{"at", AT},
+ 	{"atomic", ATOMIC},
  	{"authorization", AUTHORIZATION},
  	{"backward", BACKWARD},
  	{"before", BEFORE},
***************
*** 77,86 ****
--- 78,89 ----
  	{"cluster", CLUSTER},
  	{"coalesce", COALESCE},
  	{"collate", COLLATE},
+ 	{"collect", COLLECT},
  	{"column", COLUMN},
  	{"comment", COMMENT},
  	{"commit", COMMIT},
  	{"committed", COMMITTED},
+ 	{"condition", CONDITION},
  	{"constraint", CONSTRAINT},
  	{"constraints", CONSTRAINTS},
  	{"conversion", CONVERSION_P},
***************
*** 119,124 ****
--- 122,128 ----
  	{"drop", DROP},
  	{"each", EACH},
+ 	{"element", ELEMENT},
  	{"else", ELSE},
  	{"encoding", ENCODING},
  	{"encrypted", ENCRYPTED},
  	{"end", END_P},
***************
*** 143,148 ****
--- 147,153 ----
  	{"from", FROM},
  	{"full", FULL},
  	{"function", FUNCTION},
+ 	{"fusion", FUSION},
  	{"global", GLOBAL},
  	{"grant", GRANT},
  	{"group", GROUP_P},
***************
*** 169,174 ****
--- 174,180 ----
  	{"int", INT_P},
  	{"integer", INTEGER},
  	{"intersect", INTERSECT},
+ 	{"intersection", INTERSECTION},
  	{"interval", INTERVAL},
  	{"into", INTO},
  	{"invoker", INVOKER},
***************
*** 195,205 ****
--- 201,214 ----
  	{"lock", LOCK_P},
  	{"match", MATCH},
  	{"maxvalue", MAXVALUE},
+ 	{"member", MEMBER},
+ 	{"merge", MERGE},
  	{"minute", MINUTE_P},
  	{"minvalue", MINVALUE},
  	{"mode", MODE},
  	{"month", MONTH_P},
  	{"move", MOVE},
+ 	{"multiset", MULTISET},
  	{"names", NAMES},
  	{"national", NATIONAL},
  	{"natural", NATURAL},
***************
*** 210,215 ****
--- 219,225 ----
  	{"nocreatedb", NOCREATEDB},
  	{"nocreateuser", NOCREATEUSER},
  	{"none", NONE},
+ 	{"normalize", NORMALIZE},
  	{"not", NOT},
  	{"nothing", NOTHING},
  	{"notify", NOTIFY},
***************
*** 294,302 ****
--- 304,314 ----
  	{"stdout", STDOUT},
  	{"storage", STORAGE},
  	{"strict", STRICT_P},
+ 	{"submultiset", SUBMULTISET},
  	{"substring", SUBSTRING},
  	{"sysid", SYSID},
  	{"table", TABLE},
+ 	{"tablesample", TABLESAMPLE},
  	{"tablespace", TABLESPACE},
  	{"temp", TEMP},
  	{"template", TEMPLATE},
***************
*** 315,320 ****
--- 327,333 ----
  	{"truncate", TRUNCATE},
  	{"trusted", TRUSTED},
  	{"type", TYPE_P},
+ 	{"uescape", UESCAPE},
  	{"uncommitted", UNCOMMITTED},
  	{"unencrypted", UNENCRYPTED},
  	{"union", UNION},
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to