Change return type of EXTRACT to numeric

Edit
ID 2679
Title Change return type of EXTRACT to numeric
CI (CFBot) Not processed
Stats (from CFBot) Unknown
Topic SQL Commands
Tags
Created 2020-08-12 07:07:23
Last modified 2021-04-06 05:46:47 (4 years ago)
Latest email 2021-04-06 05:48:21 (4 years ago)
Status
2021-03 (2021-03-01 – 2021-03-31): Committed
2021-01 (2021-01-01 – 2021-01-31): Moved to different CF
2020-09 (2020-09-01 – 2020-09-30): Moved to different CF
Target version
Authors Peter Eisentraut (petere)
Reviewers Become reviewer
Committer Peter Eisentraut (petere)
Links
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