NotificationsYou must be signed in to change notification settings
Fork6
Star31

Commitd63571a

Thomas G. Lockhart

committed

Allow a string argument to the EXTRACT() function.

This is an extension to the SQL9x standard, but is consistant with usage of the underlying date_part() function used to implement it. Example: EXTRACT('YEAR',...)No impact on regression tests.

1 parent892d46e commitd63571aCopy full SHA for d63571a

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: 7 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`		`- * $Header: /cvsroot/pgsql/src/backend/parser/gram.y,v 2.221 2001/02/18 18:06:10petere Exp $`
	`14`	`+ * $Header: /cvsroot/pgsql/src/backend/parser/gram.y,v 2.222 2001/05/01 01:36:10thomas Exp $`
`15`	`15`	`*`
`16`	`16`	`* HISTORY`
`17`	`17`	`* AUTHORDATEMAJOR EVENT`
`@@ -4986,8 +4986,13 @@ extract_list: extract_arg FROM a_expr`
`4986`	`4986`	`{$$ = NIL; }`
`4987`	`4987`	`;`
`4988`	`4988`
	`4989`	`+/* Allow delimited string SCONST in extract_arg as an SQL extension.`
	`4990`	`+ * - thomas 2001-04-12`
	`4991`	`+*/`
	`4992`	`+`
`4989`	`4993`	`extract_arg:datetime{$$ =$1; }`
`4990`		`-\|IDENT{$$ =$1; }`
	`4994`	`+\|SCONST{$$ =$1; }`
	`4995`	`+\|IDENT{$$ =$1; }`
`4991`	`4996`	`\|TIMEZONE_HOUR{$$ ="tz_hour"; }`
`4992`	`4997`	`\|TIMEZONE_MINUTE{$$ ="tz_minute"; }`
`4993`	`4998`	`;`

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!

Commitd63571a

File tree

1 file changed

1 file changed

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

0 commit comments