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 (1 month ago)

Latest email

2024-08-16 16:15:58 (1 month 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

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