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
