Mark Butler writes:
> I was trying to make a minor change today to the gram.y file to make
> PostgreSQL recognize "DOUBLE" as a data type the way DB2 does. I ran into
> reduce / reduce conflicts using both of the methods I tried.
See attached patch.
--
Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/
Index: gram.y
===================================================================
RCS file: /home/projects/pgsql/cvsroot/pgsql/src/backend/parser/gram.y,v
retrieving revision 2.221
diff -u -r2.221 gram.y
--- gram.y 2001/02/18 18:06:10 2.221
+++ gram.y 2001/04/12 18:08:02
@@ -3893,6 +3893,12 @@
$$->name = xlateSqlType("float8");
$$->typmod = -1;
}
+ | DOUBLE
+ {
+ $$ = makeNode(TypeName);
+ $$->name = xlateSqlType("float8");
+ $$->typmod = -1;
+ }
| DECIMAL opt_decimal
{
$$ = makeNode(TypeName);
@@ -5407,6 +5413,7 @@
ColId: IDENT { $$ = $1; }
| datetime { $$ = $1; }
| TokenId { $$ = $1; }
+ | DOUBLE { $$ =
+"double"; }
| INTERVAL { $$ =
"interval"; }
| NATIONAL { $$ =
"national"; }
| NONE { $$ = "none";
}
@@ -5452,7 +5459,6 @@
| DEFERRED { $$ =
"deferred"; }
| DELETE { $$ =
"delete"; }
| DELIMITERS { $$ = "delimiters"; }
- | DOUBLE { $$ =
"double"; }
| DROP { $$ = "drop";
}
| EACH { $$ = "each";
}
| ENCODING { $$ =
"encoding"; }
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
