Define the right-hand input of AT TIME ZONE as a full a_expr instead of

tglsfdc · tglsfdc · commit c114e166e5eb · 2005-04-23T17:22:16.000Z
c_expr.  Perhaps the restriction was once needed to avoid bison errors,
but it seems to work just fine now --- and even generates a slightly
smaller state machine.  This change allows examples like
SELECT '13:45'::timetz AT TIME ZONE '-07:00'::interval;
to work without parentheses around the right-hand input.
diff --git a/src/backend/parser/gram.y b/src/backend/parser/gram.y
@@ -11,7 +11,7 @@
  *
  *
  * IDENTIFICATION
- *	  $PostgreSQL: pgsql/src/backend/parser/gram.y,v 2.487 2005/04/07 01:51:38 neilc Exp $
+ *	  $PostgreSQL: pgsql/src/backend/parser/gram.y,v 2.488 2005/04/23 17:22:16 tgl Exp $
  *
  * HISTORY
  *	  AUTHOR			DATE			MAJOR EVENT
@@ -6070,7 +6070,7 @@ opt_interval:
 a_expr:		c_expr									{ $$ = $1; }
 			| a_expr TYPECAST Typename
 					{ $$ = makeTypeCast($1, $3); }
-			| a_expr AT TIME ZONE c_expr
+			| a_expr AT TIME ZONE a_expr
 				{
 					FuncCall *n = makeNode(FuncCall);
 					n->funcname = SystemFuncName("timezone");

Original file line number	Diff line number	Diff line change
`@@ -11,7 +11,7 @@`
`11`	`11`	`*`
`12`	`12`	`*`
`13`	`13`	`* IDENTIFICATION`
`14`		`- * $PostgreSQL: pgsql/src/backend/parser/gram.y,v 2.487 2005/04/07 01:51:38 neilc Exp $`
	`14`	`+ * $PostgreSQL: pgsql/src/backend/parser/gram.y,v 2.488 2005/04/23 17:22:16 tgl Exp $`
`15`	`15`	`*`
`16`	`16`	`* HISTORY`
`17`	`17`	`* AUTHOR DATE MAJOR EVENT`
`@@ -6070,7 +6070,7 @@ opt_interval:`
`6070`	`6070`	`a_expr: c_expr { $$ = $1; }`
`6071`	`6071`	`\| a_expr TYPECAST Typename`
`6072`	`6072`	`{ $$ = makeTypeCast($1, $3); }`
`6073`		`- \| a_expr AT TIME ZONE c_expr`
	`6073`	`+ \| a_expr AT TIME ZONE a_expr`
`6074`	`6074`	`{`
`6075`	`6075`	`FuncCall *n = makeNode(FuncCall);`
`6076`	`6076`	`n->funcname = SystemFuncName("timezone");`