Horton

Re: Support for jsonpath .datetime() method

Alexander Korotkov <a.korotkov@postgrespro.ru>

View thread View on postgr.es
From: Alexander Korotkov <a.korotkov@postgrespro.ru>
To: Liudmila Mantrova <l.mantrova@postgrespro.ru>
Cc: Anastasia Lubennikova <lubennikovaav@gmail.com>, PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>, Nikita Glukhov <n.gluhov@postgrespro.ru>
Date: 2019-07-20T22:42:35Z
Lists: pgsql-hackers

Attachments

Hi, Liudmila!

On Fri, Jul 19, 2019 at 5:30 PM Liudmila Mantrova
<l.mantrova@postgrespro.ru> wrote:
> I had look at the added docs and would like to suggest a couple of
> changes. Please see the attached patches with my my edits for func.sgml
> and some of the comments.

Thank you for your edits, they look good to me.  Attached patchset
contains your edits as well as revised commit messages.

> Looks like we also need to change the following entry in
> features-unsupported.sgml, and probably move it to features-supported.sgml?
>
>   <row>
>    <entry>T832</entry>
>    <entry></entry>
>    <entry>SQL/JSON path language: item method</entry>
>    <entry>datetime() not yet implemented</entry>
>   </row>

Yes, that's it.  Attached patch updates sql_features.txt, which is a
source for generation of both features-unsupported.sgml and
features-supported.sgml.

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

Commits

  1. Allow datetime values in JsonbValue

  2. Error suppression support for upcoming jsonpath .datetime() method

  3. Implement jsonpath .datetime() method

  4. Implement parse_datetime() function

  5. Implement standard datetime parsing mode

  6. Support for SSSSS datetime format pattern

  7. Support for FF1-FF6 datetime format patterns