Add more tests for EXTRACT of date type
Peter Eisentraut <peter@eisentraut.org>
Add more tests for EXTRACT of date type EXTRACT of date type is implemented as a wrapper around EXTRACT of timestamp, so the code is already tested there. But the externally visible behavior of EXTRACT on date is not recorded anywhere. Since there is some discussion about reimplementing or refactoring some of this, add some more explicit tests of EXTRACT on date, similar in structure to existing EXTRACT tests on other data types. Discussion: https://www.postgresql.org/message-id/flat/42b73d2d-da12-ba9f-570a-420e0cce19d9@phystech.edu
Files
| Path | Change | +/− |
|---|---|---|
| src/test/regress/expected/date.out | modified | +180 −12 |
| src/test/regress/expected/expressions.out | modified | +2 −2 |
| src/test/regress/sql/date.sql | modified | +46 −3 |
Discussion
- Since '2001-09-09 01:46:40'::timestamp microseconds are lost when extracting epoch 47 messages · 2019-11-30 → 2021-06-08