Fix extract(interval) for week and quarter fields

Edit
ID 4979
Title Fix extract(interval) for week and quarter fields
Topic Miscellaneous
Created 2024-05-07 21:31:38
Last modified 2024-08-16 16:36:31 (2 months, 4 weeks ago)
Latest email 2024-08-16 16:15:58 (2 months, 4 weeks ago)
Status
2024-09: Committed
2024-07: Moved to next CF
Target version
Authors Tom Lane (tgl)
Reviewers Martijn Wallet (mwallet)Become reviewer
Committer Tom Lane (tgl)
Links CFbot results (CirrusCI) CFbot GitHub
Checkout latest CFbot patchset Go to your local checkout of the PostgreSQL repository and run:
git remote add commitfest https://github.com/postgresql-cfbot/postgresql.git
git fetch commitfest cf/4979
git checkout commitfest/cf/4979
Emails
BUG #18348: Inconsistency with EXTRACT([field] from INTERVAL);
First at 2024-02-16 12:06:55 by PG Bug reporting form <noreply at postgresql.org>
Latest at 2024-08-16 16:15:58 by Bruce Momjian <bruce at momjian.us>
Latest attachment (extract.sql) at 2024-08-16 02:45:58 from Bruce Momjian <bruce at momjian.us>
    Attachment (extract.sql) at 2024-08-16 02:45:58 from Bruce Momjian <bruce at momjian.us> (Patch: No)
    Attachment (v3-interval-week-and-quarter-fixes.patch) at 2024-07-08 17:03:28 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    Attachment (v2-interval-week-and-quarter-fixes.patch) at 2024-05-07 21:27:08 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    Attachment (interval-week-and-quarter-fixes.patch) at 2024-02-20 20:56:04 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    Attachment (v2-interval-extract-docs-fixes.patch) at 2024-02-19 17:22:33 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    Attachment (0003-clarify-interval-behavior.patch) at 2024-02-17 20:30:25 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    Attachment (0001-update-extract-description.patch) at 2024-02-17 18:14:19 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
History
When Who What
2024-08-16 16:36:31 Tom Lane (tgl) Closed in commitfest 2024-09 with status: Committed
2024-08-16 16:36:31 Tom Lane (tgl) Changed committer to tgl
2024-08-01 04:47:58 Corey Huinker (coreyh) Closed in commitfest 2024-07 with status: Moved to next CF
2024-05-18 14:47:29 Martijn Wallet (mwallet) Posted comment with messageid <171604364924.1105.2419464368321420465.pgcf@coridan.postgresql.org>
2024-05-18 14:02:17 Martijn Wallet (mwallet) Posted review with messageid <171604093771.1105.9806509117918884888.pgcf@coridan.postgresql.org>
2024-05-18 14:02:17 Martijn Wallet (mwallet) New status: Ready for Committer
2024-05-18 13:49:57 Martijn Wallet (mwallet) Added mwallet as reviewer
2024-05-07 21:31:45 Tom Lane (tgl) Changed authors to Tom Lane (tgl)
2024-05-07 21:31:38 Tom Lane (tgl) Attached mail thread 18348-b097a3587dfde8a4@postgresql.org
2024-05-07 21:31:38 Tom Lane (tgl) Created patch record
Edit