Fix extract(interval) for week and quarter fields

Title

Topic

Miscellaneous

Created

2024-05-07 21:31:38

Last modified

2024-08-16 16:36:31 (3 months ago)

Latest email

2024-08-16 16:15:58 (3 months 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

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