Re: SQL/JSON: functions

From: Nikita Glukhov <n(dot)gluhov(at)postgrespro(dot)ru>
To: Thomas Munro <thomas(dot)munro(at)gmail(dot)com>, Andrew Alsup <bluesbreaker(at)gmail(dot)com>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Andres Freund <andres(at)anarazel(dot)de>, Dmitry Dolgov <9erthalion6(at)gmail(dot)com>, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>, Oleg Bartunov <obartunov(at)postgrespro(dot)ru>, Alexander Korotkov <a(dot)korotkov(at)postgrespro(dot)ru>, Michael Paquier <michael(at)paquier(dot)xyz>, Simon Riggs <simon(at)2ndquadrant(dot)com>, Andrew Dunstan <andrew(dot)dunstan(at)2ndquadrant(dot)com>
Subject: Re: SQL/JSON: functions
Date: 2019-07-16 13:59:58
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

On 15.07.2019 5:35, Thomas Munro wrote:

> On Tue, May 14, 2019 at 12:54 PM Andrew Alsup <bluesbreaker(at)gmail(dot)com> wrote:
>> On 3/5/19 5:35 PM, Nikita Glukhov wrote:
>>> Attached 36th version of the patches rebased onto jsonpath v36.
>> While testing this patch a found a few issues:
>> [1] I was not able to apply the patch to the current HEAD. However, it
>> applies cleanly to commit: e988878f85 (NOTE: I did not investigate which
>> commit between e988878f85 and HEAD caused problems).
> Thanks for that note, which should help other reviewers/testers
> looking a this patch set in CF1. I hope we can eventually get a
> rebased patch set, though.
Attached 37th version of the patches rebased onto current master.

Preliminary patch #1 contains:
 - implementation of jsonpath .datetime() method (see [1])
 - jsonpath support for json type (should be posted later in a separate


Nikita Glukhov
Postgres Professional:
The Russian Postgres Company

Attachment Content-Type Size
0001-Jsonpath-support-for-datetime-and-json-v37.patch.gz application/gzip 60.8 KB
0002-Add-invisible-coercion-form-v37.patch.gz application/gzip 1.6 KB
0003-Add-function-formats-v37.patch.gz application/gzip 2.6 KB
0004-SQLJSON-constructors-v37.patch.gz application/gzip 31.5 KB
0005-IS-JSON-predicate-v37.patch.gz application/gzip 10.6 KB
0006-SQLJSON-query-functions-v37.patch.gz application/gzip 29.7 KB

In response to


Browse pgsql-hackers by date

  From Date Subject
Next Message Amit Kapila 2019-07-16 14:02:08 Re: POC: Cleaning up orphaned files using undo logs
Previous Message Tom Lane 2019-07-16 13:59:52 Re: getting ERROR "relation 16401 has no triggers" with partition foreign key alter