Change return type of EXTRACT to numeric

Edit
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 (2 years, 11 months ago)
Latest email 2021-04-06 05:48:21 (2 years, 11 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
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