Cleanup up include files.

16 files changed, 283 insertions, 503 deletions

diff --git a/src/backend/catalog/heap.c b/src/backend/catalog/heap.c
index 512e2a0fe3..c7806862ba 100644
--- a/src/backend/catalog/heap.c
+++ b/src/backend/catalog/heap.c
@@ -7,7 +7,7 @@
  *
  *
  * IDENTIFICATION
- *	  $Header: /cvsroot/pgsql/src/backend/catalog/heap.c,v 1.34 1997/11/25 21:58:40 momjian Exp $
+ *	  $Header: /cvsroot/pgsql/src/backend/catalog/heap.c,v 1.35 1997/11/26 01:10:46 momjian Exp $
  *
  * INTERFACE ROUTINES
  *		heap_creatr()			- Create an uncataloged heap relation
@@ -1528,7 +1528,7 @@ start:;
 		{
 			if (*cast != 0)
 				elog(WARN, "DEFAULT: const type mismatched");
-			sprintf(cast, ":: %s", get_id_typname(atp->atttypid));
+			sprintf(cast, ":: %s", typeidTypeName(atp->atttypid));
 			goto start;
 		}
 	}
diff --git a/src/backend/executor/execTuples.c b/src/backend/executor/execTuples.c
index d541f29d9e..8debd9c5c7 100644
--- a/src/backend/executor/execTuples.c
+++ b/src/backend/executor/execTuples.c
@@ -14,7 +14,7 @@
  *
  *
  * IDENTIFICATION
- *	  $Header: /cvsroot/pgsql/src/backend/executor/execTuples.c,v 1.11 1997/11/25 21:59:16 momjian Exp $
+ *	  $Header: /cvsroot/pgsql/src/backend/executor/execTuples.c,v 1.12 1997/11/26 01:10:54 momjian Exp $
  *
  *-------------------------------------------------------------------------
  */
@@ -988,7 +988,7 @@ ExecTypeFromTL(List *targetList)
 							   resdom->resno,
 							   resdom->resname,
 			/* fix for SELECT NULL ... */
-						  get_id_typname(restype ? restype : UNKNOWNOID),
+						  typeidTypeName(restype ? restype : UNKNOWNOID),
 							   0,
 							   false);
 
@@ -1021,7 +1021,7 @@ ExecTypeFromTL(List *targetList)
 			TupleDescInitEntry(typeInfo,
 							   fjRes->resno,
 							   fjRes->resname,
-							   get_id_typname(restype),
+							   typeidTypeName(restype),
 							   0,
 							   false);
 /*
@@ -1044,7 +1044,7 @@ ExecTypeFromTL(List *targetList)
 				TupleDescInitEntry(typeInfo,
 								   fjRes->resno,
 								   fjRes->resname,
-								   get_id_typname(restype),
+								   typeidTypeName(restype),
 								   0,
 								   false);
 
diff --git a/src/backend/parser/analyze.c b/src/backend/parser/analyze.c
index 4a3800a8a4..30bdd9c062 100644
--- a/src/backend/parser/analyze.c
+++ b/src/backend/parser/analyze.c
@@ -7,7 +7,7 @@
  *
  *
  * IDENTIFICATION
- *	  $Header: /cvsroot/pgsql/src/backend/parser/analyze.c,v 1.50 1997/11/25 22:00:27 momjian Exp $
+ *	  $Header: /cvsroot/pgsql/src/backend/parser/analyze.c,v 1.51 1997/11/26 01:11:03 momjian Exp $
  *
  *-------------------------------------------------------------------------
  */
@@ -15,18 +15,18 @@
 #include <stdio.h>
 #include <stdlib.h>
 #include <string.h>
-#include "postgres.h"
 
+#include "postgres.h"
 #include "access/heapam.h"
 #include "nodes/makefuncs.h"
 #include "nodes/memnodes.h"
 #include "nodes/pg_list.h"
 #include "parser/analyze.h"
 #include "parser/parse_agg.h"
+#include "parser/parse_clause.h"
 #include "parser/parse_node.h"
 #include "parser/parse_relation.h"
 #include "parser/parse_target.h"
-#include "parser/parse_clause.h"
 #include "utils/builtins.h"
 #include "utils/mcxt.h"
 
diff --git a/src/backend/parser/keywords.c b/src/backend/parser/keywords.c
index 1c4b63c44e..0e17dc1224 100644
--- a/src/backend/parser/keywords.c
+++ b/src/backend/parser/keywords.c
@@ -7,16 +7,16 @@
  *
  *
  * IDENTIFICATION
- *	  $Header: /cvsroot/pgsql/src/backend/parser/keywords.c,v 1.25 1997/11/25 22:05:32 momjian Exp $
+ *	  $Header: /cvsroot/pgsql/src/backend/parser/keywords.c,v 1.26 1997/11/26 01:11:08 momjian Exp $
  *
  *-------------------------------------------------------------------------
  */
 #include <ctype.h>
 #include <string.h>
-#include "postgres.h"
 
-#include "nodes/pg_list.h"
+#include "postgres.h"
 #include "nodes/parsenodes.h"
+#include "nodes/pg_list.h"
 #include "parse.h"
 #include "parser/keywords.h"
 #include "utils/elog.h"
diff --git a/src/backend/parser/parse_agg.c b/src/backend/parser/parse_agg.c
index b64b92079e..33e7f677a9 100644
--- a/src/backend/parser/parse_agg.c
+++ b/src/backend/parser/parse_agg.c
@@ -7,7 +7,7 @@
  *
  *
  * IDENTIFICATION
- *	  $Header: /cvsroot/pgsql/src/backend/parser/parse_agg.c,v 1.1 1997/11/25 22:05:34 momjian Exp $
+ *	  $Header: /cvsroot/pgsql/src/backend/parser/parse_agg.c,v 1.2 1997/11/26 01:11:14 momjian Exp $
  *
  *-------------------------------------------------------------------------
  */
@@ -27,23 +27,6 @@
 #include "parser/parse_target.h"
 #include "utils/syscache.h"
 
-#ifdef 0
-#include "nodes/nodes.h"
-#include "nodes/params.h"
-#include "parse.h"				/* for AND, OR, etc. */
-#include "catalog/pg_type.h"	/* for INT4OID, etc. */
-#include "catalog/pg_proc.h"
-#include "utils/elog.h"
-#include "utils/builtins.h"		/* namecmp(), textout() */
-#include "utils/lsyscache.h"
-#include "utils/palloc.h"
-#include "utils/mcxt.h"
-#include "utils/acl.h"
-#include "nodes/makefuncs.h"	/* for makeResdom(), etc. */
-#include "commands/sequence.h"
-
-#endif
-
 /*
  * AddAggToParseState -
  *	  add the aggregate to the list of unique aggregates in pstate.
diff --git a/src/backend/parser/parse_clause.c b/src/backend/parser/parse_clause.c
index 8e08e00a2e..3f419716d8 100644
--- a/src/backend/parser/parse_clause.c
+++ b/src/backend/parser/parse_clause.c
@@ -7,49 +7,23 @@
  *
  *
  * IDENTIFICATION
- *	  $Header: /cvsroot/pgsql/src/backend/parser/parse_clause.c,v 1.1 1997/11/25 22:05:35 momjian Exp $
+ *	  $Header: /cvsroot/pgsql/src/backend/parser/parse_clause.c,v 1.2 1997/11/26 01:11:16 momjian Exp $
  *
  *-------------------------------------------------------------------------
  */
 #include <stdio.h>
 #include <stdlib.h>
 #include <string.h>
+
 #include "postgres.h"
 #include "access/heapam.h"
+#include "catalog/pg_type.h"
 #include "parser/parse_clause.h"
 #include "parser/parse_expr.h"
 #include "parser/parse_node.h"
 #include "parser/parse_oper.h"
 #include "parser/parse_relation.h"
 #include "parser/parse_target.h"
-#include "catalog/pg_type.h"
-
-#ifdef 0
-#include "nodes/nodes.h"
-#include "nodes/params.h"
-#include "nodes/primnodes.h"
-#include "nodes/parsenodes.h"
-#include "nodes/relation.h"
-#include "parse.h"				/* for AND, OR, etc. */
-#include "catalog/pg_aggregate.h"
-#include "catalog/pg_proc.h"
-#include "utils/elog.h"
-#include "utils/builtins.h"		/* namecmp(), textout() */
-#include "utils/lsyscache.h"
-#include "utils/palloc.h"
-#include "utils/mcxt.h"
-#include "utils/syscache.h"
-#include "utils/acl.h"
-#include "nodes/makefuncs.h"	/* for makeResdom(), etc. */
-#include "nodes/nodeFuncs.h"
-#include "commands/sequence.h"
-
-#include "optimizer/clauses.h"
-
-#include "miscadmin.h"
-
-#include "port-protos.h"		/* strdup() */
-#endif
 
 /*
  * parseFromClause -
diff --git a/src/backend/parser/parse_expr.c b/src/backend/parser/parse_expr.c
index fe00b2b48a..5828fbb974 100644
--- a/src/backend/parser/parse_expr.c
+++ b/src/backend/parser/parse_expr.c
@@ -7,7 +7,7 @@
  *
  *
  * IDENTIFICATION
- *	  $Header: /cvsroot/pgsql/src/backend/parser/parse_expr.c,v 1.1 1997/11/25 22:05:39 momjian Exp $
+ *	  $Header: /cvsroot/pgsql/src/backend/parser/parse_expr.c,v 1.2 1997/11/26 01:11:17 momjian Exp $
  *
  *-------------------------------------------------------------------------
  */
@@ -21,34 +21,14 @@
 #include "nodes/nodes.h"
 #include "nodes/params.h"
 #include "nodes/relation.h"
+#include "parse.h"
 #include "parser/parse_expr.h"
 #include "parser/parse_func.h"
 #include "parser/parse_node.h"
 #include "parser/parse_relation.h"
 #include "parser/parse_target.h"
-#include "parse.h"
 #include "utils/builtins.h"
 
-#ifdef 0
-#include "nodes/primnodes.h"
-#include "nodes/parsenodes.h"
-#include "catalog/pg_aggregate.h"
-#include "catalog/pg_proc.h"
-#include "utils/elog.h"
-#include "utils/lsyscache.h"
-#include "utils/palloc.h"
-#include "utils/mcxt.h"
-#include "utils/syscache.h"
-#include "utils/acl.h"
-#include "nodes/nodeFuncs.h"
-#include "commands/sequence.h"
-
-#include "optimizer/clauses.h"
-#include "access/heapam.h"
-
-#include "miscadmin.h"
-#endif
-
 Oid param_type(int t); /* from gram.y */
 
 /*
diff --git a/src/backend/parser/parse_func.c b/src/backend/parser/parse_func.c
index bb2a7773fd..1583dc56f0 100644
--- a/src/backend/parser/parse_func.c
+++ b/src/backend/parser/parse_func.c
@@ -7,14 +7,13 @@
  *
  *
  * IDENTIFICATION
- *	  $Header: /cvsroot/pgsql/src/backend/parser/parse_func.c,v 1.1 1997/11/25 22:05:41 momjian Exp $
+ *	  $Header: /cvsroot/pgsql/src/backend/parser/parse_func.c,v 1.2 1997/11/26 01:11:21 momjian Exp $
  *
  *-------------------------------------------------------------------------
  */
 #include <string.h>
+
 #include "postgres.h"
-#include "fmgr.h"
-#include "miscadmin.h"
 #include "access/genam.h"
 #include "access/heapam.h"
 #include "access/itup.h"
@@ -25,7 +24,9 @@
 #include "catalog/pg_inherits.h"
 #include "catalog/pg_proc.h"
 #include "catalog/pg_type.h"
+#include "fmgr.h"
 #include "lib/dllist.h"
+#include "miscadmin.h"
 #include "nodes/makefuncs.h"
 #include "nodes/relation.h"
 #include "parser/parse_agg.h"
@@ -41,28 +42,6 @@
 #include "utils/lsyscache.h"
 #include "utils/syscache.h"
 
-#ifdef 0
-#include "utils/datum.h"
-
-#include "utils/elog.h"
-#include "utils/palloc.h"
-
-#include "nodes/pg_list.h"
-#include "nodes/parsenodes.h"
-
-#include "catalog/pg_operator.h"
-#include "catalog/catname.h"
-
-#include "access/skey.h"
-#include "access/tupdesc.h"
-#include "access/htup.h"
-#include "access/genam.h"
-#include "access/itup.h"
-#include "access/tupmacs.h"
-
-#include "storage/buf.h"
-#endif
-
 #define ISCOMPLEX(type) (typeidTypeRelid(type) ? true : false)
 
 #define MAXFARGS 8				/* max # args to a c or postquel function */
diff --git a/src/backend/parser/parse_node.c b/src/backend/parser/parse_node.c
index c06e00888b..574bce472c 100644
--- a/src/backend/parser/parse_node.c
+++ b/src/backend/parser/parse_node.c
@@ -7,7 +7,7 @@
  *
  *
  * IDENTIFICATION
- *	  $Header: /cvsroot/pgsql/src/backend/parser/parse_node.c,v 1.1 1997/11/25 22:05:42 momjian Exp $
+ *	  $Header: /cvsroot/pgsql/src/backend/parser/parse_node.c,v 1.2 1997/11/26 01:11:22 momjian Exp $
  *
  *-------------------------------------------------------------------------
  */
@@ -15,33 +15,19 @@
 #include <string.h>
 
 #include "postgres.h"
-#include "fmgr.h"
 #include "access/heapam.h"
 #include "catalog/pg_operator.h"
 #include "catalog/pg_type.h"
+#include "fmgr.h"
 #include "nodes/makefuncs.h"
 #include "parser/parse_expr.h"
-#include "parser/parse_oper.h"
 #include "parser/parse_node.h"
+#include "parser/parse_oper.h"
 #include "parser/parse_relation.h"
 #include "parser/parse_type.h"
 #include "utils/builtins.h"
 #include "utils/syscache.h"
 
-#ifdef 0
-#include "access/tupmacs.h"
-#include "utils/elog.h"
-#include "utils/palloc.h"
-#include "utils/acl.h"			/* for ACL_NO_PRIV_WARNING */
-#include "utils/rel.h"			/* Relation stuff */
-
-#include "utils/syscache.h"
-
-#include "nodes/pg_list.h"
-#include "nodes/primnodes.h"
-#include "nodes/parsenodes.h"
-#endif
-
 /*
  * make_parsestate() --
  *	  allocate and initialize a new ParseState.
diff --git a/src/backend/parser/parse_oper.c b/src/backend/parser/parse_oper.c
index d82a46bc2f..e3932806f3 100644
--- a/src/backend/parser/parse_oper.c
+++ b/src/backend/parser/parse_oper.c
@@ -7,55 +7,24 @@
  *
  *
  * IDENTIFICATION
- *	  $Header: /cvsroot/pgsql/src/backend/parser/parse_oper.c,v 1.1 1997/11/25 22:05:43 momjian Exp $
+ *	  $Header: /cvsroot/pgsql/src/backend/parser/parse_oper.c,v 1.2 1997/11/26 01:11:24 momjian Exp $
  *
  *-------------------------------------------------------------------------
  */
 #include <string.h>
+
 #include "postgres.h"
 #include <fmgr.h>
-
-#include <access/heapam.h>
-#include <access/relscan.h>
-#include <catalog/catname.h>
-#include <catalog/pg_operator.h>
-#include <catalog/pg_proc.h>
-#include <catalog/pg_type.h>
-#include <parser/parse_oper.h>
-#include <parser/parse_type.h>
-#include <storage/bufmgr.h>
-#include <utils/syscache.h>
-
-#ifdef 0
-#include "lib/dllist.h"
-#include "utils/datum.h"
-
-#include "utils/builtins.h"
-#include "utils/elog.h"
-#include "utils/palloc.h"
-
-#include "nodes/pg_list.h"
-#include "nodes/parsenodes.h"
-
-#include "catalog/pg_inherits.h"
+#include "access/heapam.h"
+#include "access/relscan.h"
+#include "catalog/catname.h"
 #include "catalog/pg_operator.h"
 #include "catalog/pg_proc.h"
-#include "catalog/indexing.h"
-#include "catalog/catname.h"
-
-#include "access/skey.h"
-#include "access/relscan.h"
-#include "access/tupdesc.h"
-#include "access/htup.h"
-#include "access/genam.h"
-#include "access/itup.h"
-#include "access/tupmacs.h"
-#include "storage/buf.h"
-#include "utils/lsyscache.h"
-#include "storage/lmgr.h"
-
-#include "port-protos.h"		/* strdup() */
-#endif
+#include "catalog/pg_type.h"
+#include "parser/parse_oper.h"
+#include "parser/parse_type.h"
+#include "storage/bufmgr.h"
+#include "utils/syscache.h"
 
 Oid
 any_ordering_op(int restype)
diff --git a/src/backend/parser/parse_relation.c b/src/backend/parser/parse_relation.c
index dd3fa2787a..7f550c6b85 100644
--- a/src/backend/parser/parse_relation.c
+++ b/src/backend/parser/parse_relation.c
@@ -7,7 +7,7 @@
  *
  *
  * IDENTIFICATION
- *	  $Header: /cvsroot/pgsql/src/backend/parser/parse_relation.c,v 1.1 1997/11/25 22:05:45 momjian Exp $
+ *	  $Header: /cvsroot/pgsql/src/backend/parser/parse_relation.c,v 1.2 1997/11/26 01:11:28 momjian Exp $
  *
  *-------------------------------------------------------------------------
  */
@@ -16,28 +16,13 @@
 
 #include "postgres.h"
 #include "access/heapam.h"
-#include <access/htup.h>
-#include <catalog/pg_type.h>
+#include "access/htup.h"
+#include "catalog/pg_type.h"
 #include "nodes/makefuncs.h"
-#include <parser/parse_relation.h>
-#include <utils/acl.h>
+#include "parser/parse_relation.h"
+#include "utils/acl.h"
 #include "utils/builtins.h"
-#include <utils/lsyscache.h>
-
-#ifdef 0
-#include "fmgr.h"
-#include "access/tupmacs.h"
-#include "utils/elog.h"
-#include "utils/palloc.h"
-#include "utils/acl.h"			/* for ACL_NO_PRIV_WARNING */
-
-#include "utils/syscache.h"
-#include "catalog/pg_operator.h"
-
-#include "nodes/pg_list.h"
-#include "nodes/primnodes.h"
-#include "nodes/parsenodes.h"
-#endif
+#include "utils/lsyscache.h"
 
 struct
 {
diff --git a/src/backend/parser/parse_target.c b/src/backend/parser/parse_target.c
index f29aa49d34..e2aff8c87d 100644
--- a/src/backend/parser/parse_target.c
+++ b/src/backend/parser/parse_target.c
@@ -7,47 +7,24 @@
  *
  *
  * IDENTIFICATION
- *	  $Header: /cvsroot/pgsql/src/backend/parser/parse_target.c,v 1.1 1997/11/25 22:05:47 momjian Exp $
+ *	  $Header: /cvsroot/pgsql/src/backend/parser/parse_target.c,v 1.2 1997/11/26 01:11:30 momjian Exp $
  *
  *-------------------------------------------------------------------------
  */
 #include <stdio.h>
 #include <stdlib.h>
 #include <string.h>
+
 #include "postgres.h"
 #include "catalog/pg_type.h"
 #include "nodes/makefuncs.h"
 #include "nodes/primnodes.h"
 #include "parser/parse_expr.h"
+#include "parser/parse_node.h"
 #include "parser/parse_relation.h"
 #include "parser/parse_target.h"
-#include "parser/parse_node.h"
 #include "utils/builtins.h"
 
-#ifdef 0
-#include "nodes/nodes.h"
-#include "nodes/params.h"
-#include "nodes/parsenodes.h"
-#include "nodes/relation.h"
-#include "parse.h"				/* for AND, OR, etc. */
-#include "catalog/pg_aggregate.h"
-#include "catalog/pg_proc.h"
-#include "utils/elog.h"
-#include "utils/palloc.h"
-#include "utils/mcxt.h"
-#include "utils/syscache.h"
-#include "utils/acl.h"
-#include "nodes/nodeFuncs.h"
-#include "commands/sequence.h"
-
-#include "optimizer/clauses.h"
-#include "access/heapam.h"
-
-#include "miscadmin.h"
-
-#include "port-protos.h"		/* strdup() */
-#endif
-
 /*
  * transformTargetList -
  *	  turns a list of ResTarget's into a list of TargetEntry's
diff --git a/src/backend/parser/parse_type.c b/src/backend/parser/parse_type.c
index 67632cdab6..c20b042de9 100644
--- a/src/backend/parser/parse_type.c
+++ b/src/backend/parser/parse_type.c
@@ -7,7 +7,7 @@
  *
  *
  * IDENTIFICATION
- *	  $Header: /cvsroot/pgsql/src/backend/parser/parse_type.c,v 1.1 1997/11/25 22:05:51 momjian Exp $
+ *	  $Header: /cvsroot/pgsql/src/backend/parser/parse_type.c,v 1.2 1997/11/26 01:11:32 momjian Exp $
  *
  *-------------------------------------------------------------------------
  */
@@ -15,46 +15,11 @@
 #include "postgres.h"
 #include "fmgr.h"
 
-#include <catalog/pg_type.h>
-#include <parser/parse_target.h>
-#include <parser/parse_type.h>
+#include "catalog/pg_type.h"
+#include "parser/parse_target.h"
+#include "parser/parse_type.h"
 #include "utils/syscache.h"
 
-#ifdef 0
-#include "lib/dllist.h"
-#include "utils/datum.h"
-
-#include "utils/builtins.h"
-#include "utils/elog.h"
-#include "utils/palloc.h"
-
-#include "nodes/pg_list.h"
-#include "nodes/parsenodes.h"
-#include "catalog/catname.h"
-
-#include "catalog/pg_inherits.h"
-#include "catalog/pg_operator.h"
-#include "catalog/pg_proc.h"
-#include "catalog/indexing.h"
-#include "catalog/catname.h"
-
-#include "access/skey.h"
-#include "access/relscan.h"
-#include "access/tupdesc.h"
-#include "access/htup.h"
-#include "access/heapam.h"
-#include "access/genam.h"
-#include "access/itup.h"
-#include "access/tupmacs.h"
-
-#include "storage/buf.h"
-#include "storage/bufmgr.h"
-#include "utils/lsyscache.h"
-#include "storage/lmgr.h"
-
-#include "port-protos.h"		/* strdup() */
-#endif
-
 /* check to see if a type id is valid,
  * returns true if it is. By using this call before calling
  * typeidType or typeidTypeName, more meaningful error messages
diff --git a/src/backend/parser/parser.c b/src/backend/parser/parser.c
index ea309c3c28..4bdecfa212 100644
--- a/src/backend/parser/parser.c
+++ b/src/backend/parser/parser.c
@@ -6,7 +6,7 @@
  *
  *
  * IDENTIFICATION
- *	  $Header: /cvsroot/pgsql/src/backend/parser/parser.c,v 1.29 1997/11/25 22:05:52 momjian Exp $
+ *	  $Header: /cvsroot/pgsql/src/backend/parser/parser.c,v 1.30 1997/11/26 01:11:36 momjian Exp $
  *
  *-------------------------------------------------------------------------
  */
@@ -15,19 +15,10 @@
 
 #include "postgres.h"
 #include "nodes/pg_list.h"
-#include "parser/parser.h"
 #include "parser/analyze.h"
-#include "parser/parse_node.h"
-
-void	init_io();		/* from scan.l */
-void	parser_init(Oid *typev, int nargs); /* from gram.y */
-int 	yyparse();		/* from gram.c */
-
-#ifdef 0
-#include "parser/parse.h"
 #include "parser/gramparse.h"
-#include "utils/palloc.h"
-#endif
+#include "parser/parse_node.h"
+#include "parser/parser.h"
 
 char	   *parseString;		/* the char* which holds the string to be
 								 * parsed */
diff --git a/src/backend/parser/scan.c b/src/backend/parser/scan.c
index fc12bad899..cc9aaac646 100644
--- a/src/backend/parser/scan.c
+++ b/src/backend/parser/scan.c
@@ -1,7 +1,7 @@
 /* A lexical scanner generated by flex */
 
 /* Scanner skeleton version:
- * $Header: /cvsroot/pgsql/src/backend/parser/Attic/scan.c,v 1.2 1997/11/17 16:33:21 thomas Exp $
+ * $Header: /cvsroot/pgsql/src/backend/parser/Attic/scan.c,v 1.3 1997/11/26 01:11:38 momjian Exp $
  */
 
 #define FLEX_SCANNER
@@ -284,47 +284,46 @@ static void yy_fatal_error YY_PROTO(( yyconst char msg[] ));
 	*yy_cp = '\0'; \
 	yy_c_buf_p = yy_cp;
 
-#define YY_NUM_RULES 41
-#define YY_END_OF_BUFFER 42
-static yyconst short int yy_acclist[173] =
+#define YY_NUM_RULES 40
+#define YY_END_OF_BUFFER 41
+static yyconst short int yy_acclist[163] =
     {   0,
        10,   10,    6,    6,   24,   24,    9,    9,   18,   18,
-       25,   25,   42,   40,   41,   39,   40,   41,   39,   41,
-       32,   40,   41,   22,   40,   41,   30,   32,   40,   41,
-       15,   40,   41,   30,   40,   41,   30,   32,   40,   41,
-       30,   32,   40,   41,   30,   32,   40,   41,   36,   40,
-       41,16418,   30,   32,   40,   41,   38,   40,   41,   38,
-       40,   41,   38,   40,   41,   38,   40,   41,   10,   41,
-        8,   41,    3,    6,   41,    3,    6,   41,    3,   41,
-        6,   41,   24,   41,   23,   41,    9,   41,   14,   41,
-       18,   41,   16,   41,   41,   41,   25,   41,   26,   41,
-
-       32,   32,   32,   33,   32,   32,   36,16418,    4,   32,
-       32,   28,   32,   38,    7,   38,   13,   10,    6,    6,
-        5,   24,    9,   18,   17,   20,   19,   20,   25,   31,
-       29,   31,   29,   31,   33,   29,    1,   32,   32,   29,
-       31,    4,   32,    4,   32,    4,   32, 8226,   37,16419,
-       38,   12,    5,   11,   21,   31,    2,    4,   32,   31,
-       38,    2,    2,    2, 8227,   37,16419,   27,   38,    2,
-       27,   38
+       25,   25,   41,   39,   40,   38,   39,   40,   38,   40,
+       31,   39,   40,   22,   39,   40,   29,   31,   39,   40,
+       15,   39,   40,   29,   39,   40,   29,   31,   39,   40,
+       29,   31,   39,   40,   29,   31,   39,   40,   35,   39,
+       40,16417,   29,   31,   39,   40,   37,   39,   40,   37,
+       39,   40,   37,   39,   40,   10,   40,    8,   40,    3,
+        6,   40,    3,    6,   40,    3,   40,    6,   40,   24,
+       40,   23,   40,    9,   40,   14,   40,   18,   40,   16,
+       40,   40,   40,   25,   40,   26,   40,   31,   31,   31,
+
+       32,   31,   31,   35,16417,    4,   31,   31,   27,   31,
+       37,    7,   13,   10,    6,    6,    5,   24,    9,   18,
+       17,   20,   19,   20,   25,   30,   28,   30,   28,   30,
+       32,   28,    1,   31,   31,   28,   30,    4,   31,    4,
+       31,    4,   31, 8225,   36,16418,   12,    5,   11,   21,
+       30,    2,    4,   31,   30,    2,    2,    2, 8226,   36,
+    16418,    2
     } ;
 
-static yyconst short int yy_accept[131] =
+static yyconst short int yy_accept[125] =
     {   0,
         1,    1,    1,    2,    3,    4,    5,    6,    7,    8,
         9,   10,   11,   12,   13,   14,   16,   19,   21,   24,
        27,   31,   34,   37,   41,   45,   49,   53,   57,   60,
-       63,   66,   69,   71,   73,   76,   79,   81,   83,   85,
-       87,   89,   91,   93,   95,   96,   97,   99,  101,  102,
-      103,  104,  105,  105,  106,  107,  109,  111,  112,  112,
-      112,  112,  114,  115,  116,  117,  118,  119,  119,  119,
-      120,  121,  121,  121,  122,  123,  124,  124,  124,  125,
-      125,  125,  126,  127,  129,  130,  131,  133,  136,  137,
-      137,  138,  139,  140,  142,  142,  144,  146,  148,  149,
-
-      151,  152,  152,  152,  153,  154,  154,  154,  155,  155,
-      155,  156,  157,  157,  160,  161,  161,  161,  161,  162,
-      163,  164,  165,  166,  166,  168,  170,  171,  173,  173
+       63,   66,   68,   70,   73,   76,   78,   80,   82,   84,
+       86,   88,   90,   92,   93,   94,   96,   98,   99,  100,
+      101,  102,  102,  103,  104,  106,  108,  109,  109,  109,
+      109,  111,  112,  113,  114,  115,  115,  115,  116,  117,
+      117,  117,  118,  119,  120,  120,  120,  121,  121,  121,
+      122,  123,  125,  126,  127,  129,  132,  133,  133,  134,
+      135,  136,  138,  138,  140,  142,  144,  145,  147,  147,
+
+      147,  148,  149,  149,  149,  150,  150,  150,  151,  152,
+      152,  155,  156,  156,  156,  156,  157,  158,  159,  160,
+      160,  162,  163,  163
     } ;
 
 static yyconst int yy_ec[256] =
@@ -337,11 +336,11 @@ static yyconst int yy_ec[256] =
        14,   14,   14,   14,   14,   14,   14,   15,    8,   16,
        16,   16,    4,    4,   17,   18,   17,   17,   19,   17,
        17,   17,   17,   17,   17,   17,   17,   17,   17,   17,
-       17,   17,   20,   17,   17,   17,   17,   21,   22,   17,
-        8,   23,    8,    4,   24,    4,   17,   18,   17,   17,
+       17,   17,   17,   17,   17,   17,   17,   20,   17,   17,
+        8,   21,    8,    4,   17,    4,   17,   18,   17,   17,
 
        19,   17,   17,   17,   17,   17,   17,   17,   17,   17,
-       17,   17,   17,   17,   17,   17,   17,   17,   17,   21,
+       17,   17,   17,   17,   17,   17,   17,   17,   17,   20,
        17,   17,    1,   16,    1,    4,    1,   17,   17,   17,
        17,   17,   17,   17,   17,   17,   17,   17,   17,   17,
        17,   17,   17,   17,   17,   17,   17,   17,   17,   17,
@@ -359,153 +358,153 @@ static yyconst int yy_ec[256] =
        17,   17,   17,   17,   17
     } ;
 
-static yyconst int yy_meta[25] =
+static yyconst int yy_meta[22] =
     {   0,
         1,    1,    2,    3,    4,    3,    5,    1,    6,    7,
         7,    8,    3,    9,    3,    3,   10,   10,    9,   10,
-       10,   10,   11,   10
+       11
     } ;
 
-static yyconst short int yy_base[150] =
+static yyconst short int yy_base[142] =
     {   0,
-        0,    0,  395,  394,   21,   34,  376,  358,  345,  333,
-       19,   28,   50,   52,  334,  403,  403,  403,  322,  403,
-       45,  403,  315,  303,   46,   53,   65,   18,    0,  298,
-      282,  193,    0,   67,    0,   76,   62,    0,    0,  403,
-        0,   70,    0,   81,  190,  403,   91,  403,  182,   84,
-       27,  172,   34,  153,   98,    0,  119,  112,  134,    0,
-      147,  144,    0,  403,  129,  403,    0,  136,  139,    0,
-        0,   65,  131,  141,    0,    0,  145,  149,    0,  151,
-      155,  403,  403,  403,  157,  403,  403,  113,  403,  159,
-      403,  119,  152,    0,   88,  172,   77,  165,  403,  187,
-
-       57,  189,  192,  403,  200,  202,  205,  403,  208,  211,
-      403,    0,  171,  214,   56,  217,    0,  211,   44,  221,
-      224,  229,  403,   14,  215,    0,  233,    0,  403,  236,
-      247,  258,  269,  280,  291,  300,  299,  309,  320,  329,
-      336,  347,  358,  368,  379,  384,  387,  388,  390
+        0,    0,  323,  311,   18,   31,  304,  303,  232,  224,
+       18,   29,   46,   49,  221,  401,  401,  401,  204,  401,
+       12,  401,  196,  189,   42,   50,   62,   43,    0,  186,
+      164,    0,   64,    0,   73,   59,    0,    0,  401,    0,
+       67,    0,   78,  154,  401,   88,  401,  144,   81,   18,
+      135,   31,  129,   95,    0,  113,  106,  128,    0,  120,
+      110,    0,  401,  401,    0,  130,  133,    0,    0,   62,
+       85,  135,    0,    0,  139,  143,    0,  145,  149,  401,
+      401,  401,  151,  401,  401,   73,  401,  153,  401,  166,
+      113,    0,   69,  179,   49,  146,  401,  194,  171,  184,
+
+      401,  196,  199,  207,  401,  209,  215,  401,    0,  171,
+      201,   46,  217,    0,  213,  223,  227,  231,  401,   24,
+      221,  235,  401,  240,  251,  262,  273,  284,  295,  304,
+      303,  313,  324,  333,  340,  351,  362,  372,  383,  388,
+      391
     } ;
 
-static yyconst short int yy_def[150] =
+static yyconst short int yy_def[142] =
     {   0,
-      129,    1,  130,  130,  131,  131,  132,  132,  133,  133,
-      134,  134,  135,  135,  129,  129,  129,  129,  136,  129,
-      136,  129,  129,  136,  136,  136,  129,  136,  137,  137,
-      137,  137,  138,  129,  139,  139,  140,   36,  141,  129,
-      142,  129,  143,  129,  144,  129,  129,  129,  136,  136,
-       50,  129,  129,   51,  129,   27,  145,   55,  129,  146,
-      129,  136,  137,  129,  137,  129,  138,  129,  129,  139,
-       36,  140,  140,  140,  141,  142,  129,  129,  143,  129,
-      129,  129,  129,  129,  129,  129,  129,  129,  129,   55,
-      129,   55,   55,   90,  145,  145,   96,   96,  129,  129,
-
-      137,  129,  129,  129,  129,  129,  129,  129,  129,  129,
-      129,   90,  145,   96,  145,  129,  147,  129,  148,  145,
-      145,  129,  129,  129,  100,  149,  129,  149,    0,  129,
-      129,  129,  129,  129,  129,  129,  129,  129,  129,  129,
-      129,  129,  129,  129,  129,  129,  129,  129,  129
+      123,    1,  124,  124,  125,  125,  126,  126,  127,  127,
+      128,  128,  129,  129,  123,  123,  123,  123,  130,  123,
+      130,  123,  123,  130,  130,  130,  123,  130,  131,  131,
+      131,  132,  123,  133,  133,  134,   35,  135,  123,  136,
+      123,  137,  123,  138,  123,  123,  123,  130,  130,   49,
+      123,  123,   50,  123,   27,  139,   54,  123,  140,  123,
+      130,  131,  123,  123,  132,  123,  123,  133,   35,  134,
+      134,  134,  135,  136,  123,  123,  137,  123,  123,  123,
+      123,  123,  123,  123,  123,  123,  123,   54,  123,   88,
+       90,   88,  139,  139,   94,   94,  123,  123,  123,  123,
+
+      123,  123,  123,  123,  123,  123,  123,  123,   88,  139,
+       94,  139,  123,  141,  123,  139,  139,  123,  123,  123,
+       98,  123,    0,  123,  123,  123,  123,  123,  123,  123,
+      123,  123,  123,  123,  123,  123,  123,  123,  123,  123,
+      123
     } ;
 
-static yyconst short int yy_nxt[428] =
+static yyconst short int yy_nxt[423] =
     {   0,
        16,   17,   18,   19,   20,   21,   22,   23,   24,   24,
        25,   23,   26,   27,   28,   24,   29,   30,   29,   31,
-       32,   29,   16,   29,   36,   44,   36,  125,   54,   37,
-       36,   36,   62,   38,   44,   36,   36,   36,   87,   36,
-       88,   45,   37,   36,   36,   89,   38,   89,   36,   36,
-       45,   47,   47,   47,   47,   51,   55,   63,   52,   56,
-       48,   57,   48,   54,  113,   58,   59,   59,   68,   69,
-       72,   77,   78,   72,   74,   60,   61,   74,   56,   71,
-      119,   71,   80,   81,   72,   71,   71,   82,   71,  114,
-       71,   71,   85,   85,   50,   86,  113,   86,   90,   90,
-
-       91,   92,   90,   92,   90,   90,   92,   92,   93,   94,
-       92,   94,   92,   92,   90,   90,   90,   90,   90,   90,
-       90,   90,   96,   90,   96,   90,   52,   97,   96,   98,
-       90,   96,   90,   96,   96,   59,   59,   68,   69,   72,
-      102,  103,  105,  105,   60,  104,   77,   78,  101,   72,
-      106,  107,   80,   81,   50,  108,  109,  110,   85,   85,
-      100,  111,   90,  112,   90,  112,   87,   90,   90,   90,
-       90,   90,   90,   90,   90,   96,  115,   96,  115,  113,
-       97,   96,   98,  120,   96,   52,   96,   96,  116,  116,
-      102,  103,   50,  102,  103,  104,   84,  117,  104,   66,
-
-      100,  105,  105,  106,  107,  118,  106,  107,  108,  109,
-      110,  108,  109,  110,  111,  121,  122,  111,  116,  116,
-      124,  124,  121,  122,  125,  121,  122,  117,  125,  113,
-      127,  122,  113,  129,  127,  122,   33,   33,   33,   33,
-       33,   33,   33,   33,   33,   33,   33,   35,   35,   35,
-       35,   35,   35,   35,   35,   35,   35,   35,   39,   39,
-       39,   39,   39,   39,   39,   39,   39,   39,   39,   41,
-       41,   41,   41,   41,   41,   41,   41,   41,   41,   41,
-       43,   43,   43,   43,   43,   43,   43,   43,   43,   43,
-       43,   46,   46,   46,   46,   46,   46,   46,   46,   46,
-
-       46,   46,   49,   65,   64,   49,   49,   63,   63,   67,
-       67,   67,   67,   54,   67,   67,   67,   67,   67,   67,
-       70,   70,   70,   70,   70,   53,   70,   70,   70,   70,
-       70,   73,   50,  129,   73,   73,   75,   75,   75,   42,
-       75,   75,   75,   75,   75,   75,   75,   76,   76,   76,
-       76,   42,   76,   76,   76,   76,   76,   76,   79,   79,
-       79,   79,   40,   79,   79,   79,   79,   79,   83,   83,
-       83,   83,   83,   83,   83,   83,   83,   83,   83,   95,
-       40,   95,   95,   95,   95,   95,   95,   95,   95,   95,
-       99,   99,   99,  123,  123,  123,  126,  126,  128,  128,
-
-       34,   34,   15,  129,  129,  129,  129,  129,  129,  129,
-      129,  129,  129,  129,  129,  129,  129,  129,  129,  129,
-      129,  129,  129,  129,  129,  129,  129
+       16,   35,   50,   35,   43,   51,   36,   35,   35,   85,
+       37,   86,   35,   35,   35,   43,   35,  121,   44,   36,
+       35,   35,   87,   37,   87,   35,   35,   46,   46,   44,
+       46,   46,   54,   53,  110,   55,   47,   61,   56,   47,
+       53,  111,   57,   58,   58,   66,   67,   70,   75,   76,
+       70,   72,   59,   60,   72,   55,   69,  110,   69,   78,
+       79,   70,   69,   69,   80,   69,   51,   69,   69,   83,
+       83,   49,   84,   70,   84,   88,   88,   89,   90,   88,
+
+       90,   88,   88,   90,   90,   91,   92,   90,   92,   90,
+       90,   88,   88,   88,   88,   88,   94,   88,   94,   88,
+       49,   95,   94,   96,  109,   94,  109,   94,   94,   58,
+       58,   66,   67,   98,   99,  100,  102,  102,   59,  101,
+       75,   76,   85,   70,  103,  104,   78,   79,   51,  105,
+      106,  107,   83,   83,   49,  108,   88,  112,   88,  112,
+       82,   88,   88,   88,   88,   88,   88,   88,   88,   90,
+       64,   90,   99,  100,   90,   90,   91,  101,   90,  110,
+       90,   90,   94,  116,   94,   99,  100,   95,   94,   96,
+      101,   94,   63,   94,   94,  113,  113,  102,  102,   53,
+
+      103,  104,  117,  118,  114,  105,   52,   98,  103,  104,
+      106,  107,  115,  105,   49,  108,  106,  107,  113,  113,
+      123,  108,  120,  120,  117,  118,  121,  114,  117,  118,
+       41,  110,  122,  118,  121,  110,  122,  118,   41,  123,
+       32,   32,   32,   32,   32,   32,   32,   32,   32,   32,
+       32,   34,   34,   34,   34,   34,   34,   34,   34,   34,
+       34,   34,   38,   38,   38,   38,   38,   38,   38,   38,
+       38,   38,   38,   40,   40,   40,   40,   40,   40,   40,
+       40,   40,   40,   40,   42,   42,   42,   42,   42,   42,
+       42,   42,   42,   42,   42,   45,   45,   45,   45,   45,
+
+       45,   45,   45,   45,   45,   45,   48,   39,   39,   48,
+       48,   62,   62,   65,   65,   65,   65,   33,   65,   65,
+       65,   65,   65,   65,   68,   68,   68,   68,   68,   33,
+       68,   68,   68,   68,   68,   71,  123,  123,   71,   71,
+       73,   73,   73,  123,   73,   73,   73,   73,   73,   73,
+       73,   74,   74,   74,   74,  123,   74,   74,   74,   74,
+       74,   74,   77,   77,   77,   77,  123,   77,   77,   77,
+       77,   77,   81,   81,   81,   81,   81,   81,   81,   81,
+       81,   81,   81,   93,  123,   93,   93,   93,   93,   93,
+       93,   93,   93,   93,   97,   97,   97,  119,  119,  119,
+
+       15,  123,  123,  123,  123,  123,  123,  123,  123,  123,
+      123,  123,  123,  123,  123,  123,  123,  123,  123,  123,
+      123,  123
     } ;
 
-static yyconst short int yy_chk[428] =
+static yyconst short int yy_chk[423] =
     {   0,
         1,    1,    1,    1,    1,    1,    1,    1,    1,    1,
         1,    1,    1,    1,    1,    1,    1,    1,    1,    1,
-        1,    1,    1,    1,    5,   11,    5,  124,   28,    5,
-        5,    5,   28,    5,   12,    5,    5,    6,   51,    6,
-       51,   11,    6,    6,    6,   53,    6,   53,    6,    6,
-       12,   13,   13,   14,   14,   21,   25,  119,   21,   25,
-       13,   26,   14,   26,  115,   26,   27,   27,   34,   34,
-       37,   42,   42,   72,   37,   27,   27,   72,   27,   36,
-      101,   36,   44,   44,   36,   36,   36,   44,   36,   97,
-       36,   36,   47,   47,   50,   50,   95,   50,   55,   55,
-
-       55,   55,   55,   55,   55,   55,   55,   55,   55,   55,
-       55,   55,   55,   55,   55,   55,   55,   55,   55,   55,
-       55,   55,   57,   58,   57,   58,   88,   57,   57,   57,
-       92,   57,   92,   57,   57,   59,   59,   68,   68,   73,
-       69,   69,   74,   74,   59,   69,   77,   77,   65,   74,
-       78,   78,   80,   80,   62,   78,   81,   81,   85,   85,
-       61,   81,   90,   93,   90,   93,   54,   90,   90,   90,
-       90,   90,   90,   90,   90,   96,   98,   96,   98,  113,
-       96,   96,   96,  113,   96,   52,   96,   96,  100,  100,
-      102,  102,   49,  103,  103,  102,   45,  100,  103,   32,
-
-      100,  105,  105,  106,  106,  100,  107,  107,  106,  109,
-      109,  107,  110,  110,  109,  114,  114,  110,  116,  116,
-      118,  118,  120,  120,  118,  121,  121,  116,  125,  120,
-      122,  122,  121,  125,  127,  127,  130,  130,  130,  130,
-      130,  130,  130,  130,  130,  130,  130,  131,  131,  131,
-      131,  131,  131,  131,  131,  131,  131,  131,  132,  132,
-      132,  132,  132,  132,  132,  132,  132,  132,  132,  133,
-      133,  133,  133,  133,  133,  133,  133,  133,  133,  133,
-      134,  134,  134,  134,  134,  134,  134,  134,  134,  134,
-      134,  135,  135,  135,  135,  135,  135,  135,  135,  135,
-
-      135,  135,  136,   31,   30,  136,  136,  137,  137,  138,
-      138,  138,  138,   24,  138,  138,  138,  138,  138,  138,
-      139,  139,  139,  139,  139,   23,  139,  139,  139,  139,
-      139,  140,   19,   15,  140,  140,  141,  141,  141,   10,
-      141,  141,  141,  141,  141,  141,  141,  142,  142,  142,
-      142,    9,  142,  142,  142,  142,  142,  142,  143,  143,
-      143,  143,    8,  143,  143,  143,  143,  143,  144,  144,
-      144,  144,  144,  144,  144,  144,  144,  144,  144,  145,
-        7,  145,  145,  145,  145,  145,  145,  145,  145,  145,
-      146,  146,  146,  147,  147,  147,  148,  148,  149,  149,
-
-        4,    3,  129,  129,  129,  129,  129,  129,  129,  129,
-      129,  129,  129,  129,  129,  129,  129,  129,  129,  129,
-      129,  129,  129,  129,  129,  129,  129
+        1,    5,   21,    5,   11,   21,    5,    5,    5,   50,
+        5,   50,    5,    5,    6,   12,    6,  120,   11,    6,
+        6,    6,   52,    6,   52,    6,    6,   13,   13,   12,
+       14,   14,   25,   28,  112,   25,   13,   28,   26,   14,
+       26,   95,   26,   27,   27,   33,   33,   36,   41,   41,
+       70,   36,   27,   27,   70,   27,   35,   93,   35,   43,
+       43,   35,   35,   35,   43,   35,   86,   35,   35,   46,
+       46,   49,   49,   71,   49,   54,   54,   54,   54,   54,
+
+       54,   54,   54,   54,   54,   54,   54,   54,   54,   54,
+       54,   54,   54,   54,   54,   54,   56,   57,   56,   57,
+       61,   56,   56,   56,   91,   56,   91,   56,   56,   58,
+       58,   66,   66,   60,   67,   67,   72,   72,   58,   67,
+       75,   75,   53,   72,   76,   76,   78,   78,   51,   76,
+       79,   79,   83,   83,   48,   79,   88,   96,   88,   96,
+       44,   88,   88,   88,   88,   88,   88,   88,   88,   90,
+       31,   90,   99,   99,   90,   90,   90,   99,   90,  110,
+       90,   90,   94,  110,   94,  100,  100,   94,   94,   94,
+      100,   94,   30,   94,   94,   98,   98,  102,  102,   24,
+
+      103,  103,  111,  111,   98,  103,   23,   98,  104,  104,
+      106,  106,   98,  104,   19,  106,  107,  107,  113,  113,
+       15,  107,  115,  115,  116,  116,  115,  113,  117,  117,
+       10,  116,  118,  118,  121,  117,  122,  122,    9,  121,
+      124,  124,  124,  124,  124,  124,  124,  124,  124,  124,
+      124,  125,  125,  125,  125,  125,  125,  125,  125,  125,
+      125,  125,  126,  126,  126,  126,  126,  126,  126,  126,
+      126,  126,  126,  127,  127,  127,  127,  127,  127,  127,
+      127,  127,  127,  127,  128,  128,  128,  128,  128,  128,
+      128,  128,  128,  128,  128,  129,  129,  129,  129,  129,
+
+      129,  129,  129,  129,  129,  129,  130,    8,    7,  130,
+      130,  131,  131,  132,  132,  132,  132,    4,  132,  132,
+      132,  132,  132,  132,  133,  133,  133,  133,  133,    3,
+      133,  133,  133,  133,  133,  134,    0,    0,  134,  134,
+      135,  135,  135,    0,  135,  135,  135,  135,  135,  135,
+      135,  136,  136,  136,  136,    0,  136,  136,  136,  136,
+      136,  136,  137,  137,  137,  137,    0,  137,  137,  137,
+      137,  137,  138,  138,  138,  138,  138,  138,  138,  138,
+      138,  138,  138,  139,    0,  139,  139,  139,  139,  139,
+      139,  139,  139,  139,  140,  140,  140,  141,  141,  141,
+
+      123,  123,  123,  123,  123,  123,  123,  123,  123,  123,
+      123,  123,  123,  123,  123,  123,  123,  123,  123,  123,
+      123,  123
     } ;
 
 static yy_state_type yy_state_buf[YY_BUF_SIZE + 2], *yy_state_ptr;
@@ -542,7 +541,7 @@ char *yytext;
  *
  *
  * IDENTIFICATION
- *	  $Header: /cvsroot/pgsql/src/backend/parser/Attic/scan.c,v 1.2 1997/11/17 16:33:21 thomas Exp $
+ *	  $Header: /cvsroot/pgsql/src/backend/parser/Attic/scan.c,v 1.3 1997/11/26 01:11:38 momjian Exp $
  *
  *-------------------------------------------------------------------------
  */
@@ -563,12 +562,11 @@ char *yytext;
 #include "parser/gramparse.h"
 #include "parser/keywords.h"
 #include "parser/scansup.h"
-#include "parser/sysfunc.h"
 #include "parse.h"
 #include "utils/builtins.h"
 
 extern char *parseString;
-extern char *parseCh;
+static char *parseCh;
 
 /* some versions of lex define this as a macro */
 #if defined(yywrap)
@@ -641,7 +639,7 @@ char literal[MAX_PARSE_BUFFER];
  * Other embedded escaped characters are matched explicitly and the leading
  *  backslash is dropped from the string. - thomas 1997-09-24
  */
-#line 645 "lex.yy.c"
+#line 643 "lex.yy.c"
 
 /* Macros after this point can all be overridden by user definitions in
  * section 1.
@@ -792,9 +790,9 @@ YY_DECL
 	register char *yy_cp, *yy_bp;
 	register int yy_act;
 
-#line 167 "scan.l"
+#line 164 "scan.l"
 
-#line 798 "lex.yy.c"
+#line 796 "lex.yy.c"
 
 	if ( yy_init )
 		{
@@ -842,14 +840,14 @@ yy_match:
 			while ( yy_chk[yy_base[yy_current_state] + yy_c] != yy_current_state )
 				{
 				yy_current_state = (int) yy_def[yy_current_state];
-				if ( yy_current_state >= 130 )
+				if ( yy_current_state >= 124 )
 					yy_c = yy_meta[(unsigned int) yy_c];
 				}
 			yy_current_state = yy_nxt[yy_base[yy_current_state] + (unsigned int) yy_c];
 			*yy_state_ptr++ = yy_current_state;
 			++yy_cp;
 			}
-		while ( yy_base[yy_current_state] != 403 );
+		while ( yy_base[yy_current_state] != 401 );
 
 yy_find_action:
 		yy_current_state = *--yy_state_ptr;
@@ -900,34 +898,34 @@ do_action:	/* This label is used only to access EOF actions. */
 	{ /* beginning of action switch */
 case 1:
 YY_RULE_SETUP
-#line 168 "scan.l"
+#line 165 "scan.l"
 { /* ignore */ }
 	YY_BREAK
 case 2:
 YY_RULE_SETUP
-#line 170 "scan.l"
+#line 167 "scan.l"
 { /* ignore */ }
 	YY_BREAK
 case 3:
-#line 173 "scan.l"
+#line 170 "scan.l"
 case 4:
 YY_RULE_SETUP
-#line 173 "scan.l"
+#line 170 "scan.l"
 { BEGIN(xc); }
 	YY_BREAK
 case 5:
 YY_RULE_SETUP
-#line 175 "scan.l"
+#line 172 "scan.l"
 { BEGIN(INITIAL); }
 	YY_BREAK
 case 6:
 YY_RULE_SETUP
-#line 177 "scan.l"
+#line 174 "scan.l"
 { /* ignore */ }
 	YY_BREAK
 case 7:
 YY_RULE_SETUP
-#line 179 "scan.l"
+#line 176 "scan.l"
 {
 					BEGIN(xb);
 					llen = 0;
@@ -936,7 +934,7 @@ YY_RULE_SETUP
 	YY_BREAK
 case 8:
 YY_RULE_SETUP
-#line 184 "scan.l"
+#line 181 "scan.l"
 {
 					char* endptr;
 
@@ -949,10 +947,10 @@ YY_RULE_SETUP
 				}
 	YY_BREAK
 case 9:
-#line 195 "scan.l"
+#line 192 "scan.l"
 case 10:
 YY_RULE_SETUP
-#line 195 "scan.l"
+#line 192 "scan.l"
 {
 					if ((llen+yyleng) > (MAX_PARSE_BUFFER - 1))
 						elog(WARN,"quoted string parse buffer of %d chars exceeded",MAX_PARSE_BUFFER);
@@ -961,16 +959,16 @@ YY_RULE_SETUP
 				}
 	YY_BREAK
 case 11:
-#line 202 "scan.l"
+#line 199 "scan.l"
 case 12:
 YY_RULE_SETUP
-#line 202 "scan.l"
+#line 199 "scan.l"
 {
 				}
 	YY_BREAK
 case 13:
 YY_RULE_SETUP
-#line 205 "scan.l"
+#line 202 "scan.l"
 {
 					BEGIN(xh);
 					llen = 0;
@@ -979,7 +977,7 @@ YY_RULE_SETUP
 	YY_BREAK
 case 14:
 YY_RULE_SETUP
-#line 210 "scan.l"
+#line 207 "scan.l"
 {
 					char* endptr;
 
@@ -993,7 +991,7 @@ YY_RULE_SETUP
 	YY_BREAK
 case 15:
 YY_RULE_SETUP
-#line 221 "scan.l"
+#line 218 "scan.l"
 {
 					BEGIN(xq);
 					llen = 0;
@@ -1002,7 +1000,7 @@ YY_RULE_SETUP
 	YY_BREAK
 case 16:
 YY_RULE_SETUP
-#line 226 "scan.l"
+#line 223 "scan.l"
 {
 					BEGIN(INITIAL);
 					yylval.str = pstrdup(scanstr(literal));
@@ -1010,10 +1008,10 @@ YY_RULE_SETUP
 				}
 	YY_BREAK
 case 17:
-#line 232 "scan.l"
+#line 229 "scan.l"
 case 18:
 YY_RULE_SETUP
-#line 232 "scan.l"
+#line 229 "scan.l"
 {
 					if ((llen+yyleng) > (MAX_PARSE_BUFFER - 1))
 						elog(WARN,"quoted string parse buffer of %d chars exceeded",MAX_PARSE_BUFFER);
@@ -1023,7 +1021,7 @@ YY_RULE_SETUP
 	YY_BREAK
 case 19:
 YY_RULE_SETUP
-#line 238 "scan.l"
+#line 235 "scan.l"
 {
 					if ((llen+yyleng-1) > (MAX_PARSE_BUFFER - 1))
 						elog(WARN,"quoted string parse buffer of %d chars exceeded",MAX_PARSE_BUFFER);
@@ -1034,7 +1032,7 @@ YY_RULE_SETUP
 	YY_BREAK
 case 20:
 YY_RULE_SETUP
-#line 246 "scan.l"
+#line 243 "scan.l"
 {
 					if ((llen+yyleng-1) > (MAX_PARSE_BUFFER - 1))
 						elog(WARN,"quoted string parse buffer of %d chars exceeded",MAX_PARSE_BUFFER);
@@ -1044,13 +1042,13 @@ YY_RULE_SETUP
 	YY_BREAK
 case 21:
 YY_RULE_SETUP
-#line 252 "scan.l"
+#line 249 "scan.l"
 {
 				}
 	YY_BREAK
 case 22:
 YY_RULE_SETUP
-#line 256 "scan.l"
+#line 253 "scan.l"
 {
 					BEGIN(xd);
 					llen = 0;
@@ -1059,7 +1057,7 @@ YY_RULE_SETUP
 	YY_BREAK
 case 23:
 YY_RULE_SETUP
-#line 261 "scan.l"
+#line 258 "scan.l"
 {
 					BEGIN(INITIAL);
 					yylval.str = pstrdup(literal);
@@ -1068,7 +1066,7 @@ YY_RULE_SETUP
 	YY_BREAK
 case 24:
 YY_RULE_SETUP
-#line 266 "scan.l"
+#line 263 "scan.l"
 {
 					if ((llen+yyleng) > (MAX_PARSE_BUFFER - 1))
 						elog(WARN,"quoted string parse buffer of %d chars exceeded",MAX_PARSE_BUFFER);
@@ -1078,12 +1076,12 @@ YY_RULE_SETUP
 	YY_BREAK
 case 25:
 YY_RULE_SETUP
-#line 274 "scan.l"
+#line 271 "scan.l"
 { /* ignore */ }
 	YY_BREAK
 case 26:
 YY_RULE_SETUP
-#line 275 "scan.l"
+#line 272 "scan.l"
 {
 					BEGIN(INITIAL);
 					return (yytext[0]);
@@ -1091,46 +1089,38 @@ YY_RULE_SETUP
 	YY_BREAK
 case 27:
 YY_RULE_SETUP
-#line 281 "scan.l"
-{
-						yylval.str = pstrdup(SystemFunctionHandler((char *)yytext));
-						return (SCONST);
-				}
-	YY_BREAK
-case 28:
-YY_RULE_SETUP
-#line 286 "scan.l"
+#line 278 "scan.l"
 { return TYPECAST; }
 	YY_BREAK
-case 29:
+case 28:
 *yy_cp = yy_hold_char; /* undo effects of setting up yytext */
 yy_c_buf_p = yy_cp = yy_bp + 1;
 YY_DO_BEFORE_ACTION; /* set up yytext again */
 YY_RULE_SETUP
-#line 288 "scan.l"
+#line 280 "scan.l"
 {
 					return (yytext[0]);
 				}
 	YY_BREAK
-case 30:
+case 29:
 YY_RULE_SETUP
-#line 291 "scan.l"
+#line 283 "scan.l"
 { 	return (yytext[0]); }
 	YY_BREAK
-case 31:
+case 30:
 *yy_cp = yy_hold_char; /* undo effects of setting up yytext */
 yy_c_buf_p = yy_cp -= 2;
 YY_DO_BEFORE_ACTION; /* set up yytext again */
 YY_RULE_SETUP
-#line 292 "scan.l"
+#line 284 "scan.l"
 {
 					yylval.str = pstrdup((char*)yytext);
 					return (Op);
 				}
 	YY_BREAK
-case 32:
+case 31:
 YY_RULE_SETUP
-#line 296 "scan.l"
+#line 288 "scan.l"
 {
 					if (strcmp((char*)yytext,"!=") == 0)
 						yylval.str = pstrdup("<>"); /* compatability */
@@ -1139,17 +1129,17 @@ YY_RULE_SETUP
 					return (Op);
 				}
 	YY_BREAK
-case 33:
+case 32:
 YY_RULE_SETUP
-#line 303 "scan.l"
+#line 295 "scan.l"
 {
 					yylval.ival = atoi((char*)&yytext[1]);
 					return (PARAM);
 				}
 	YY_BREAK
-case 34:
+case 33:
 YY_RULE_SETUP
-#line 308 "scan.l"
+#line 300 "scan.l"
 {
 					char* endptr;
 
@@ -1161,9 +1151,9 @@ YY_RULE_SETUP
 					return (ICONST);
 				}
 	YY_BREAK
-case 35:
+case 34:
 YY_RULE_SETUP
-#line 318 "scan.l"
+#line 310 "scan.l"
 {
 					char* endptr;
 
@@ -1176,9 +1166,9 @@ YY_RULE_SETUP
 					return (FCONST);
 				}
 	YY_BREAK
-case 36:
+case 35:
 YY_RULE_SETUP
-#line 329 "scan.l"
+#line 321 "scan.l"
 {
 					char* endptr;
 
@@ -1189,9 +1179,9 @@ YY_RULE_SETUP
 					return (ICONST);
 				}
 	YY_BREAK
-case 37:
+case 36:
 YY_RULE_SETUP
-#line 338 "scan.l"
+#line 330 "scan.l"
 {
 					char* endptr;
 
@@ -1203,9 +1193,9 @@ YY_RULE_SETUP
 					return (FCONST);
 				}
 	YY_BREAK
-case 38:
+case 37:
 YY_RULE_SETUP
-#line 348 "scan.l"
+#line 340 "scan.l"
 {
 					int i;
 					ScanKeyword		*keyword;
@@ -1225,22 +1215,22 @@ YY_RULE_SETUP
 					}
 				}
 	YY_BREAK
-case 39:
+case 38:
 YY_RULE_SETUP
-#line 366 "scan.l"
+#line 358 "scan.l"
 { /* ignore */ }
 	YY_BREAK
-case 40:
+case 39:
 YY_RULE_SETUP
-#line 368 "scan.l"
+#line 360 "scan.l"
 { return (yytext[0]); }
 	YY_BREAK
-case 41:
+case 40:
 YY_RULE_SETUP
-#line 370 "scan.l"
+#line 362 "scan.l"
 ECHO;
 	YY_BREAK
-#line 1244 "lex.yy.c"
+#line 1234 "lex.yy.c"
 			case YY_STATE_EOF(INITIAL):
 			case YY_STATE_EOF(xb):
 			case YY_STATE_EOF(xc):
@@ -1535,7 +1525,7 @@ static yy_state_type yy_get_previous_state()
 		while ( yy_chk[yy_base[yy_current_state] + yy_c] != yy_current_state )
 			{
 			yy_current_state = (int) yy_def[yy_current_state];
-			if ( yy_current_state >= 130 )
+			if ( yy_current_state >= 124 )
 				yy_c = yy_meta[(unsigned int) yy_c];
 			}
 		yy_current_state = yy_nxt[yy_base[yy_current_state] + (unsigned int) yy_c];
@@ -1565,11 +1555,11 @@ yy_state_type yy_current_state;
 	while ( yy_chk[yy_base[yy_current_state] + yy_c] != yy_current_state )
 		{
 		yy_current_state = (int) yy_def[yy_current_state];
-		if ( yy_current_state >= 130 )
+		if ( yy_current_state >= 124 )
 			yy_c = yy_meta[(unsigned int) yy_c];
 		}
 	yy_current_state = yy_nxt[yy_base[yy_current_state] + (unsigned int) yy_c];
-	yy_is_jam = (yy_current_state == 129);
+	yy_is_jam = (yy_current_state == 123);
 	if ( ! yy_is_jam )
 		*yy_state_ptr++ = yy_current_state;
 
@@ -2126,7 +2116,7 @@ int main()
 	return 0;
 	}
 #endif
-#line 370 "scan.l"
+#line 362 "scan.l"
 
 
 void yyerror(char message[])
diff --git a/src/backend/parser/scansup.c b/src/backend/parser/scansup.c
index e50757940a..84ef988ddb 100644
--- a/src/backend/parser/scansup.c
+++ b/src/backend/parser/scansup.c
@@ -8,7 +8,7 @@
  *
  *
  * IDENTIFICATION
- *	  $Header: /cvsroot/pgsql/src/backend/parser/scansup.c,v 1.8 1997/11/25 22:05:55 momjian Exp $
+ *	  $Header: /cvsroot/pgsql/src/backend/parser/scansup.c,v 1.9 1997/11/26 01:11:40 momjian Exp $
  *
  *-------------------------------------------------------------------------
  */
@@ -17,10 +17,11 @@
 
 #include <ctype.h>
 #include <string.h>
+
 #include "postgres.h"
 #include "miscadmin.h"
-#include "utils/elog.h"
 #include "parser/scansup.h"
+#include "utils/elog.h"
 
 /* ----------------
  *		scanstr