Re: Support for jsonpath .datetime() method

Alexander Korotkov <a.korotkov@postgrespro.ru>

From: Alexander Korotkov <a.korotkov@postgrespro.ru>

To: pgsql-hackers <pgsql-hackers@postgresql.org>

Date: 2019-07-01T16:28:13Z

Lists: pgsql-hackers

Attachments

0001-datetime-in-JsonbValue-2.patch (application/octet-stream) patch 0001
0002-datetime-conversion-for-jsonpath-2.patch (application/octet-stream) patch 0002
0004-implement-jsonpath-datetime-2.patch (application/octet-stream) patch 0004
0003-error-suppression-for-datetime-2.patch (application/octet-stream) patch 0003

On Tue, May 28, 2019 at 8:55 AM Alexander Korotkov
<a.korotkov@postgrespro.ru> wrote:
> Attached patchset implements jsonpath .datetime() method.

Revised patchset is attached.  Some inconsistencies around
parse_datetime() function are fixed.  Rebased to current master as
well.

------
Alexander Korotkov
Postgres Professional: http://www.postgrespro.com
The Russian Postgres Company

Commits

Allow datetime values in JsonbValue
- 6dda292d4df8 13.0 landed
Error suppression support for upcoming jsonpath .datetime() method
- 5bc450629b31 13.0 landed
Implement jsonpath .datetime() method
- bffe1bd68457 13.0 landed
Implement parse_datetime() function
- 66c74f8b6e34 13.0 landed
Implement standard datetime parsing mode
- 1a950f37d0a2 13.0 landed
Support for SSSSS datetime format pattern
- b64b857f50fb 13.0 landed
Support for FF1-FF6 datetime format patterns
- d589f94460c2 13.0 landed