Change return type of EXTRACT to numeric

Title

Topic

SQL Commands

Created

2020-08-12 07:07:23

Last modified

2021-02-01 12:48:53 (3 weeks, 5 days ago)

Latest email

2020-12-15 14:03:31 (2 months, 2 weeks ago)

Status

2021-03: Needs review

2021-01: Moved to next CF

2020-09: Moved to next CF

Target version

Authors

Peter Eisentraut (petere)

Reviewers

Committer

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 2020-12-15 14:03:31 by Peter Eisentraut <peter.eisentraut at 2ndquadrant.com>
Latest 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>
    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-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