NotificationsYou must be signed in to change notification settings
Fork5
Star26

Commitc114e16

committed

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

c_expr. Perhaps the restriction was once needed to avoid bison errors,but it seems to work just fine now --- and even generates a slightlysmaller state machine. This change allows examples likeSELECT '13:45'::timetz AT TIME ZONE '-07:00'::interval;to work without parentheses around the right-hand input.

1 parent0975b95 commitc114e16Copy full SHA for c114e16

File tree

1 file changed

-2

lines changed

src/backend/parser
- gram.y

1 file changed

-2

lines changed

`‎src/backend/parser/gram.y`

Lines changed: 2 additions & 2 deletions

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`	`* AUTHORDATEMAJOR 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 ZONEc_expr`
	`6073`	`+\| a_expr AT TIME ZONEa_expr`
`6074`	`6074`	`{`
`6075`	`6075`	`FuncCall *n = makeNode(FuncCall);`
`6076`	`6076`	`n->funcname = SystemFuncName("timezone");`

0 commit comments

Comments

(0)

Movatterモバイル変換

Navigation Menu

Search code, repositories, users, issues, pull requests...

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Commitc114e16

File tree

1 file changed

1 file changed

`‎src/backend/parser/gram.y`

0 commit comments