Allow LIKE expression in constraint clause.

Thomas G. Lockhart · Thomas G. Lockhart · commit 64ebb583bc29 · 1998-02-18T07:25:57.000Z
Allow USER and VALID as column names and identifiers.
diff --git a/src/backend/parser/gram.y b/src/backend/parser/gram.y
@@ -10,7 +10,7 @@
  *
  *
  * IDENTIFICATION
- *	  $Header: /cvsroot/pgsql/src/backend/parser/gram.y,v 2.3 1998/02/18 03:26:54 vadim Exp $
+ *	  $Header: /cvsroot/pgsql/src/backend/parser/gram.y,v 2.4 1998/02/18 07:25:57 thomas Exp $
  *
  * HISTORY
  *	  AUTHOR			DATE			MAJOR EVENT
@@ -994,6 +994,8 @@ constraint_expr:  AexprConst
 				}
 			| constraint_expr Op constraint_expr
 				{	$$ = nconc( $1, lcons( makeString( $2), $3)); }
+			| constraint_expr LIKE constraint_expr
+				{	$$ = nconc( $1, lcons( makeString( "like"), $3)); }
 			| constraint_expr AND constraint_expr
 				{	$$ = nconc( $1, lcons( makeString( "AND"), $3)); }
 			| constraint_expr OR constraint_expr
@@ -4620,6 +4622,8 @@ ColId:  IDENT							{ $$ = $1; }
 		| TIME							{ $$ = "time"; }
 		| TRIGGER						{ $$ = "trigger"; }
 		| TYPE_P						{ $$ = "type"; }
+		| USER							{ $$ = "user"; }
+		| VALID							{ $$ = "valid"; }
 		| VERSION						{ $$ = "version"; }
 		| ZONE							{ $$ = "zone"; }
 		;

Original file line number	Diff line number	Diff line change
`@@ -10,7 +10,7 @@`
`10`	`10`	`*`
`11`	`11`	`*`
`12`	`12`	`* IDENTIFICATION`
`13`		`- * $Header: /cvsroot/pgsql/src/backend/parser/gram.y,v 2.3 1998/02/18 03:26:54 vadim Exp $`
	`13`	`+ * $Header: /cvsroot/pgsql/src/backend/parser/gram.y,v 2.4 1998/02/18 07:25:57 thomas Exp $`
`14`	`14`	`*`
`15`	`15`	`* HISTORY`
`16`	`16`	`* AUTHOR DATE MAJOR EVENT`
`@@ -994,6 +994,8 @@ constraint_expr: AexprConst`
`994`	`994`	`}`
`995`	`995`	`\| constraint_expr Op constraint_expr`
`996`	`996`	`{ $$ = nconc( $1, lcons( makeString( $2), $3)); }`
	`997`	`+ \| constraint_expr LIKE constraint_expr`
	`998`	`+ { $$ = nconc( $1, lcons( makeString( "like"), $3)); }`
`997`	`999`	`\| constraint_expr AND constraint_expr`
`998`	`1000`	`{ $$ = nconc( $1, lcons( makeString( "AND"), $3)); }`
`999`	`1001`	`\| constraint_expr OR constraint_expr`
`@@ -4620,6 +4622,8 @@ ColId: IDENT { $$ = $1; }`
`4620`	`4622`	`\| TIME { $$ = "time"; }`
`4621`	`4623`	`\| TRIGGER { $$ = "trigger"; }`
`4622`	`4624`	`\| TYPE_P { $$ = "type"; }`
	`4625`	`+ \| USER { $$ = "user"; }`
	`4626`	`+ \| VALID { $$ = "valid"; }`
`4623`	`4627`	`\| VERSION { $$ = "version"; }`
`4624`	`4628`	`\| ZONE { $$ = "zone"; }`
`4625`	`4629`	`;`