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, 7 months ago)

Latest email 2021-04-06 05:48:21 (3 years, 7 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