diff options
| author | Thomas G. Lockhart <lockhart@fourpalms.org> | 2001-05-01 01:36:10 +0000 |
|---|---|---|
| committer | Thomas G. Lockhart <lockhart@fourpalms.org> | 2001-05-01 01:36:10 +0000 |
| commit | d63571a7f4639155d2dd1ca703a9b720d6e48e16 (patch) | |
| tree | 0a584601d8e60cd75bc1f0ea633b06c77d53aeee | |
| parent | 892d46e7d053df7e29468d9cd5077a05c0d74905 (diff) | |
| download | postgresql-d63571a7f4639155d2dd1ca703a9b720d6e48e16.tar.gz postgresql-d63571a7f4639155d2dd1ca703a9b720d6e48e16.zip | |
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.
| -rw-r--r-- | src/backend/parser/gram.y | 9 |
1 files changed, 7 insertions, 2 deletions
diff --git a/src/backend/parser/gram.y b/src/backend/parser/gram.y index 7908cec825f..bed0ce239a4 100644 --- a/src/backend/parser/gram.y +++ b/src/backend/parser/gram.y @@ -11,7 +11,7 @@ * * * IDENTIFICATION - * $Header: /cvsroot/pgsql/src/backend/parser/gram.y,v 2.221 2001/02/18 18:06:10 petere Exp $ + * $Header: /cvsroot/pgsql/src/backend/parser/gram.y,v 2.222 2001/05/01 01:36:10 thomas Exp $ * * HISTORY * AUTHOR DATE MAJOR EVENT @@ -4986,8 +4986,13 @@ extract_list: extract_arg FROM a_expr { $$ = NIL; } ; +/* Allow delimited string SCONST in extract_arg as an SQL extension. + * - thomas 2001-04-12 + */ + extract_arg: datetime { $$ = $1; } - | IDENT { $$ = $1; } + | SCONST { $$ = $1; } + | IDENT { $$ = $1; } | TIMEZONE_HOUR { $$ = "tz_hour"; } | TIMEZONE_MINUTE { $$ = "tz_minute"; } ; |