In 8.3, it appears that NUMERIC doesn't need to be a key word any longer. See attached patch. Was there a reason this was kept in the parser? Otherwise we could remove it in 8.4.
-- Peter Eisentraut http://developer.postgresql.org/~petere/
diff -ur ../cvs-pgsql/src/backend/parser/gram.y ./src/backend/parser/gram.y --- ../cvs-pgsql/src/backend/parser/gram.y 2008-01-04 15:55:24.000000000 +0100 +++ ./src/backend/parser/gram.y 2008-01-29 16:00:59.000000000 +0100 @@ -412,7 +412,7 @@ NAME_P NAMES NATIONAL NATURAL NCHAR NEW NEXT NO NOCREATEDB NOCREATEROLE NOCREATEUSER NOINHERIT NOLOGIN_P NONE NOSUPERUSER - NOT NOTHING NOTIFY NOTNULL NOWAIT NULL_P NULLIF NULLS_P NUMERIC + NOT NOTHING NOTIFY NOTNULL NOWAIT NULL_P NULLIF NULLS_P OBJECT_P OF OFF OFFSET OIDS OLD ON ONLY OPERATOR OPTION OR ORDER OUT_P OUTER_P OVERLAPS OVERLAY OWNED OWNER @@ -6986,12 +6986,6 @@ $$->typmods = $2; $$->location = @1; } - | NUMERIC opt_type_modifiers - { - $$ = SystemTypeName("numeric"); - $$->typmods = $2; - $$->location = @1; - } | BOOLEAN_P { $$ = SystemTypeName("bool"); @@ -9266,7 +9260,6 @@ | NCHAR | NONE | NULLIF - | NUMERIC | OUT_P | OVERLAY | POSITION diff -ur ../cvs-pgsql/src/backend/parser/keywords.c ./src/backend/parser/keywords.c --- ../cvs-pgsql/src/backend/parser/keywords.c 2008-01-04 15:55:24.000000000 +0100 +++ ./src/backend/parser/keywords.c 2008-01-29 16:01:09.000000000 +0100 @@ -251,7 +251,6 @@ {"null", NULL_P, RESERVED_KEYWORD}, {"nullif", NULLIF, COL_NAME_KEYWORD}, {"nulls", NULLS_P, UNRESERVED_KEYWORD}, - {"numeric", NUMERIC, COL_NAME_KEYWORD}, {"object", OBJECT_P, UNRESERVED_KEYWORD}, {"of", OF, UNRESERVED_KEYWORD}, {"off", OFF, RESERVED_KEYWORD},
---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly