Change return type of EXTRACT to numeric

Edit
ID 2679
Title Change return type of EXTRACT to numeric
Topic SQL Commands
Created 2020-08-12 07:07:23
Last modified 2021-04-06 05:46:47 (3 years, 8 months ago)
Latest email 2021-04-06 05:48:21 (3 years, 8 months ago)
Status
2021-03: Committed
2021-01: Moved to next CF
2020-09: Moved to next CF
Target version
Authors Peter Eisentraut (petere)
Reviewers Become reviewer
Committer Peter Eisentraut (petere)
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/2679
git checkout commitfest/cf/2679
Emails
Since '2001-09-09 01:46:40'::timestamp microseconds are lost when extracting epoch
First at 2019-11-30 09:28:18 by Petr Fedorov <petr.fedorov at phystech.edu>
Latest at 2021-04-06 05:48:21 by Peter Eisentraut <peter.eisentraut at 2ndquadrant.com>
Latest attachment (v6-0001-Change-return-type-of-EXTRACT-to-numeric.patch) at 2021-04-01 18:49:45 from Peter Eisentraut <peter.eisentraut at 2ndquadrant.com>
    Attachment (v6-0001-Change-return-type-of-EXTRACT-to-numeric.patch) at 2021-04-01 18:49:45 from Peter Eisentraut <peter.eisentraut at 2ndquadrant.com> (Patch: Yes)
    Attachment (petest.sql) at 2021-03-23 20:52:01 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: No)
    Attachment (output.txt) at 2021-03-22 20:58:20 from Peter Eisentraut <peter.eisentraut at 2ndquadrant.com> (Patch: No)
    Attachment (v5-0001-Change-return-type-of-EXTRACT-to-numeric.patch) at 2021-03-19 19:37:04 from Peter Eisentraut <peter.eisentraut at 2ndquadrant.com> (Patch: Yes)
    Attachment (v4-0001-Change-return-type-of-EXTRACT-to-numeric.patch) at 2020-12-15 14:03:31 from Peter Eisentraut <peter.eisentraut at 2ndquadrant.com> (Patch: Yes)
    Attachment (reverse-list-special-sql-syntaxes-3.patch) at 2020-11-04 00:22:14 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    Attachment (reverse-list-special-sql-syntaxes-2.patch) at 2020-11-02 22:50:08 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    Attachment (reverse-list-special-sql-syntaxes-1.patch) at 2020-10-31 23:57:23 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    Attachment (v3-0002-expose-int64_to_numeric.patch) at 2020-09-06 23:46:32 from Tom Lane <tgl at sss.pgh.pa.us> (Patch: Yes)
    Attachment (v2-0001-Add-more-tests-for-extract-of-date-type.patch) at 2020-08-12 07:04:07 from Peter Eisentraut <peter.eisentraut at 2ndquadrant.com> (Patch: Yes)
    Attachment (v1-0001-Change-return-type-of-EXTRACT-to-numeric.patch) at 2020-08-04 14:08:07 from Peter Eisentraut <peter.eisentraut at 2ndquadrant.com> (Patch: Yes)
History
When Who What
2021-04-06 11:43:01 John Naylor (john.naylor) Removed john.naylor from reviewers
2021-04-06 05:46:47 Peter Eisentraut (petere) Closed in commitfest 2021-03 with status: Committed
2021-04-06 05:46:47 Peter Eisentraut (petere) Changed committer to petere
2021-03-21 15:38:11 John Naylor (john.naylor) New status: Needs review
2021-03-18 11:38:48 John Naylor (john.naylor) New status: Waiting on Author
2021-03-03 13:40:41 John Naylor (john.naylor) Added john.naylor as reviewer
2021-02-01 12:48:53 Masahiko Sawada (masahikosawada) Closed in commitfest 2021-01 with status: Moved to next CF
2020-12-15 14:04:08 Peter Eisentraut (petere) Closed in commitfest 2020-09 with status: Moved to next CF
2020-12-15 14:03:59 Peter Eisentraut (petere) New status: Needs review
2020-09-30 07:15:48 Michael Paquier (michael-kun) Closed in commitfest 2020-09 with status: Returned with feedback
2020-09-10 13:20:38 Peter Eisentraut (petere) New status: Waiting on Author
2020-08-12 07:07:34 Peter Eisentraut (petere) Changed authors to Peter Eisentraut (petere)
2020-08-12 07:07:23 Peter Eisentraut (petere) Attached mail thread 42b73d2d-da12-ba9f-570a-420e0cce19d9@phystech.edu
2020-08-12 07:07:23 Peter Eisentraut (petere) Created patch record
Edit