[I] `extract` doesn't accept quoted field names [datafusion]

[via GitHub]

erratic-pattern opened a new issue, #10826:
URL: https://github.com/apache/datafusion/issues/10826

   ### Describe the bug
   
   In postgreSQL, the following query is valid:
   ```sql
   SELECT extract('epoch' FROM now());
   ```
   However, in Datafusion I get the following error:
   ```
   Invalid statement: sql parser error: Expected date/time field, found: 'epoch'
   ```
   
   
   ### To Reproduce
   
   Attempt to run the above query in DataFusion CLI with the default PostgreSQL 
dialect.
   
   ### Expected behavior
   
   The query should parse successfully and produce results similar to the 
following example from `psql`:
   ```
   postgres=# select extract('epoch' from now());
         extract
   -------------------
    1717761399.492846
   (1 row)
   ```
   
   ### Additional context
   
   _No response_


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: github-unsubscr...@datafusion.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
us...@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscr...@datafusion.apache.org
For additional commands, e-mail: github-h...@datafusion.apache.org