Change return type of EXTRACT to numeric

Title

Topic

SQL Commands

Created

2020-08-12 07:07:23

Last modified

2021-04-06 05:46:47 (3 months, 3 weeks ago)

Latest email

2021-04-06 05:48:21 (3 months, 3 weeks 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