*

*

* IDENTIFICATION

* $Header: /cvsroot/pgsql/src/backend/parser/gram.y,v 2.6 1998/03/07 06:04:59 thomas Exp $

* $Header: /cvsroot/pgsql/src/backend/parser/gram.y,v 2.7 1998/03/18 16:50:19 thomas Exp $

*

* HISTORY

* AUTHORDATEMAJOR EVENT

%type <sortgroupby>

join_using

%type <boolean>opt_union

%type <boolean>opt_table

%type <node>position_expr

%type <list>extract_list, position_list

%type <list>OptCreateAs, CreateAsList

%type <node>CreateAsElement

%type <value>NumConst

%type <value>IntegerOnly

%type <attr>event_object, attr

%type <sortgroupby>groupby

%type <sortgroupby>sortby

/* Keywords for Postgres support (not in SQL92 reserved words) */

%tokenABORT_TRANS, AFTER, AGGREGATE, ANALYZE,

BACKWARD, BEFORE, BINARY, CLUSTER, COPY,

BACKWARD, BEFORE, BINARY,CACHE,CLUSTER, COPY, CYCLE,

DATABASE, DELIMITERS, DO, EACH, EXPLAIN, EXTEND,

FORWARD, FUNCTION, HANDLER,

INDEX, INHERITS, INSTEAD, ISNULL,

LANCOMPILER, LISTEN, LOAD, LOCK_P, LOCATION, MOVE,

INCREMENT,INDEX, INHERITS, INSTEAD, ISNULL,

LANCOMPILER, LISTEN, LOAD, LOCK_P, LOCATION,MAXVALUE, MINVALUE,MOVE,

NEW, NONE, NOTHING, NOTNULL, OIDS, OPERATOR, PROCEDURAL,

RECIPE, RENAME, RESET, RETURNS, ROW, RULE,

SEQUENCE, SETOF, SHOW, STATEMENT, STDIN, STDOUT, TRUSTED,

SEQUENCE, SETOF, SHOW,START,STATEMENT, STDIN, STDOUT, TRUSTED,

VACUUM, VERBOSE, VERSION

/* Keywords (obsolete; retain through next version for parser - thomas 1997-12-04) */

*

*****************************************************************************/

CreateSeqStmt:CREATE SEQUENCE relation_name OptSeqList

CreateSeqStmt:CREATE SEQUENCE relation_name OptSeqList

{

CreateSeqStmt *n = makeNode(CreateSeqStmt);

n->seqname = $3;

}

;

OptSeqList:

OptSeqList OptSeqElem

OptSeqList: OptSeqList OptSeqElem

{ $$ = lappend($1, $2); }

|{ $$ = NIL; }

|{ $$ = NIL; }

;

OptSeqElem:IDENT NumConst

OptSeqElem: CACHE IntegerOnly

{

$$ = makeNode(DefElem);

$$->defname =$1;

$$->defname ="cache";

$$->arg = (Node *)$2;

}

{

$$ = makeNode(DefElem);

$$->defname =$1;

$$->defname ="cycle";

$$->arg = (Node *)NULL;

}

| INCREMENT IntegerOnly

{

$$ = makeNode(DefElem);

$$->defname = "increment";

$$->arg = (Node *)$2;

}

| MAXVALUE IntegerOnly

{

$$ = makeNode(DefElem);

$$->defname = "maxvalue";

$$->arg = (Node *)$2;

}

| MINVALUE IntegerOnly

{

$$ = makeNode(DefElem);

$$->defname = "minvalue";

$$->arg = (Node *)$2;

}

| START IntegerOnly

{

$$ = makeNode(DefElem);

$$->defname = "start";

$$->arg = (Node *)$2;

}

;

IntegerOnly: Iconst

{

$$ = makeInteger($1);

}

| '-' Iconst

{

$$ = makeInteger($2);

$$->val.ival = - $$->val.ival;

}

;

/*****************************************************************************

;

opt_instead: INSTEAD{ $$ = TRUE; }

| /*EMPTY*/{ $$ = FALSE; }

| /*EMPTY*/{ $$ = FALSE; }

;

| /*EMPTY*/{ $$ = FALSE; }

;

opt_va_list: '(' va_list ')'

{ $$ = $2; }

| /* EMPTY */

{ $$ = NIL; }

opt_va_list: '(' va_list ')'{ $$ = $2; }

| /*EMPTY*/{ $$ = NIL; }

;

va_list: name

*Is it worth making this a separate command, with

*its own node type and file. I don't think so. bjm 1998/1/22

*/

LockStmt: LOCK_P relation_name

LockStmt: LOCK_Popt_tablerelation_name

{

DeleteStmt *n = makeNode(DeleteStmt);

A_Const *c = makeNode(A_Const);

c->typename->name = xlateSqlType("bool");

c->typename->typmod = -1;

n->relname = $2;

n->relname = $3;

n->whereClause = (Node *)c;

$$ = (Node *)n;

}

}

;

result: INTO TABLE relation_name

{$$= $3; }

| /*EMPTY*/

{$$ = NULL; }

result: INTO opt_table relation_name{ $$= $3; }

| /*EMPTY*/{ $$ = NULL; }

;

opt_table: TABLE{ $$ = TRUE; }

| /*EMPTY*/{ $$ = FALSE; }

;

opt_union: ALL{ $$ = TRUE; }

ColId: IDENT{ $$ = $1; }

| datetime{ $$ = $1; }

| ACTION{ $$ = "action"; }

| CACHE{ $$ = "cache"; }

| CYCLE{ $$ = "cycle"; }

| DATABASE{ $$ = "database"; }

| DELIMITERS{ $$ = "delimiters"; }

| DOUBLE{ $$ = "double"; }

| EACH{ $$ = "each"; }

| FUNCTION{ $$ = "function"; }

| INCREMENT{ $$ = "increment"; }

| INDEX{ $$ = "index"; }

| KEY{ $$ = "key"; }

| LANGUAGE{ $$ = "language"; }

| LOCATION{ $$ = "location"; }

| MATCH{ $$ = "match"; }

| MAXVALUE{ $$ = "maxvalue"; }

| MINVALUE{ $$ = "minvalue"; }

| OPERATOR{ $$ = "operator"; }

| OPTION{ $$ = "option"; }

| PASSWORD{ $$ = "password"; }

| PRIVILEGES{ $$ = "privileges"; }

| RECIPE{ $$ = "recipe"; }

| ROW{ $$ = "row"; }

{"binary",BINARY},

{"both",BOTH},

{"by",BY},

{"cache",CACHE},

{"cascade",CASCADE},

{"cast",CAST},

{"char",CHAR},

{"current_timestamp",CURRENT_TIMESTAMP},

{"current_user",CURRENT_USER},

{"cursor",CURSOR},

{"cycle",CYCLE},

{"database",DATABASE},

{"day",DAY_P},

{"decimal",DECIMAL},

{"having",HAVING},

{"hour",HOUR_P},

{"in",IN},

{"increment",INCREMENT},

{"index",INDEX},

{"inherits",INHERITS},

{"inner",INNER_P},

{"location",LOCATION},

{"lock",LOCK_P},

{"match",MATCH},

{"maxvalue",MAXVALUE},

{"minute",MINUTE_P},

{"minvalue",MINVALUE},

{"month",MONTH_P},

{"move",MOVE},

{"national",NATIONAL},

{"set",SET},

{"setof",SETOF},

{"show",SHOW},

{"start",START},

{"statement",STATEMENT},

{"stdin",STDIN},

{"stdout",STDOUT},

#defineBACKWARD383

#defineBEFORE384

#defineBINARY385

#defineCLUSTER386

#defineCOPY387

#defineDATABASE388

#defineDELIMITERS389

#defineDO390

#defineEACH391

#defineEXPLAIN392

#defineEXTEND393

#defineFORWARD394

#defineFUNCTION395

#defineHANDLER396

#defineINDEX397

#defineINHERITS398

#defineINSTEAD399

#defineISNULL400

#defineLANCOMPILER401

#defineLISTEN402

#defineLOAD403

#defineLOCK_P404

#defineLOCATION405

#defineMOVE406

#defineNEW407

#defineNONE408

#defineNOTHING409

#defineNOTNULL410

#defineOIDS411

#defineOPERATOR412

#definePROCEDURAL413

#defineRECIPE414

#defineRENAME415

#defineRESET416

#defineRETURNS417

#defineROW418

#defineRULE419

#defineSEQUENCE420

#defineSETOF421

#defineSHOW422

#defineSTATEMENT423

#defineSTDIN424

#defineSTDOUT425

#defineTRUSTED426

#defineVACUUM427

#defineVERBOSE428

#defineVERSION429

#defineARCHIVE430

#defineUSER431

#definePASSWORD432

#defineCREATEDB433

#defineNOCREATEDB434

#defineCREATEUSER435

#defineNOCREATEUSER436

#defineVALID437

#defineUNTIL438

#defineIDENT439

#defineSCONST440

#defineOp441

#defineICONST442

#definePARAM443

#defineFCONST444

#defineOP445

#defineUMINUS446

#defineTYPECAST447

#defineREDUCE448

#defineCACHE386

#defineCLUSTER387

#defineCOPY388

#defineCYCLE389

#defineDATABASE390

#defineDELIMITERS391

#defineDO392

#defineEACH393

#defineEXPLAIN394

#defineEXTEND395

#defineFORWARD396

#defineFUNCTION397

#defineHANDLER398

#defineINCREMENT399

#defineINDEX400

#defineINHERITS401

#defineINSTEAD402

#defineISNULL403

#defineLANCOMPILER404

#defineLISTEN405

#defineLOAD406

#defineLOCK_P407

#defineLOCATION408

#defineMAXVALUE409

#defineMINVALUE410

#defineMOVE411

#defineNEW412

#defineNONE413

#defineNOTHING414

#defineNOTNULL415

#defineOIDS416

#defineOPERATOR417

#definePROCEDURAL418

#defineRECIPE419

#defineRENAME420

#defineRESET421

#defineRETURNS422

#defineROW423

#defineRULE424

#defineSEQUENCE425

#defineSETOF426

#defineSHOW427

#defineSTART428

#defineSTATEMENT429

#defineSTDIN430

#defineSTDOUT431

#defineTRUSTED432

#defineVACUUM433

#defineVERBOSE434

#defineVERSION435

#defineARCHIVE436

#defineUSER437

#definePASSWORD438

#defineCREATEDB439

#defineNOCREATEDB440

#defineCREATEUSER441

#defineNOCREATEUSER442

#defineVALID443

#defineUNTIL444

#defineIDENT445

#defineSCONST446

#defineOp447

#defineICONST448

#definePARAM449

#defineFCONST450

#defineOP451

#defineUMINUS452

#defineTYPECAST453

#defineREDUCE454

externYYSTYPEyylval;