| From: | Oleg Bartunov <obartunov(at)postgrespro(dot)ru> |
|---|---|
| To: | Nikita Glukhov <n(dot)gluhov(at)postgrespro(dot)ru> |
| Cc: | Alexander Korotkov <a(dot)korotkov(at)postgrespro(dot)ru>, tgl Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Andrew Dunstan <andrew(dot)dunstan(at)2ndquadrant(dot)com>, Jeff Janes <jeff(dot)janes(at)gmail(dot)com>, Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>, Andres Freund <andres(at)anarazel(dot)de>, Michael Paquier <michael(at)paquier(dot)xyz>, Stas Kelvich <s(dot)kelvich(at)postgrespro(dot)ru>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>, Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com>, David Steele <david(at)pgmasters(dot)net>, Robert Haas <robertmhaas(at)gmail(dot)com>, Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com> |
| Subject: | Re: jsonpath |
| Date: | 2019-03-22 03:46:35 |
| Message-ID: | CAF4Au4yvGo5hEkK1qKNdkakOwRrztzED=V_Ygs8skUzp8+MV5g@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Fri, 22 Mar 2019, 03:14 Nikita Glukhov, <n(dot)gluhov(at)postgrespro(dot)ru> wrote:
> Hi.
>
> Attached patch enables throwing of errors in jsonb_path_match() in its
> non-silent mode when the jsonpath expression failed to return a singleton
> boolean. Previously, NULL was always returned, and it seemed to be
> inconsistent with the behavior of other functions, in which structural and
> other errors were not suppressed in non-silent mode.
>
>
> We also think that jsonb_path_match() needs to be renamed, because its
> current name is confusing to many users. "Match" name is more suitable for
> jsonpath-based pattern matching like that (maybe we'll implement it later):
>
> jsonb_path_match(
> '{ "a": 1, "b": 2, "c": "str" }',
> '{ "a": 1, "b": @ > 1, * : @.type == "string" }'
> )
>
> Would be very useful for constraints.
>
> Below are some possible name variants:
>
> jsonb_path_predicate() (original name)
>
> Too long
jsonb_path_pred()
> jsonb_path_test()
> jsonb_path_check()
>
>
Check is good to me
>
> jsonb_path_bool()
>
> --
> Nikita Glukhov
> Postgres Professional: http://www.postgrespro.com
> The Russian Postgres Company
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Paquier | 2019-03-22 04:00:26 | Re: pg_basebackup ignores the existing data directory permissions |
| Previous Message | Haribabu Kommi | 2019-03-22 03:45:24 | Re: pg_basebackup ignores the existing data directory permissions |