| From: | Alexander Korotkov <akorotkov(at)postgresql(dot)org> |
|---|---|
| To: | pgsql-committers(at)lists(dot)postgresql(dot)org |
| Subject: | pgsql: Support 'q' flag in jsonpath 'like_regex' predicate |
| Date: | 2019-06-19 19:42:42 |
| Message-ID: | E1hdgTi-0005xb-N4@gemulon.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-committers |
Support 'q' flag in jsonpath 'like_regex' predicate
SQL/JSON standard defines that jsonpath 'like_regex' predicate should support
the same set of flags as XQuery/XPath. It appears that implementation of 'q'
flag was missed. This commit fixes that.
Discussion: https://postgr.es/m/CAPpHfdtyfPsxLYiTjp5Ov8T5xGsB5t3CwE5%2B3PS%3DLLwA%2BxTJog%40mail.gmail.com
Author: Nikita Glukhov, Alexander Korotkov
Branch
------
master
Details
-------
https://git.postgresql.org/pg/commitdiff/261a5c1928566f938cbda0f62dc16f6a2d1e871d
Modified Files
--------------
src/backend/utils/adt/jsonpath.c | 2 ++
src/backend/utils/adt/jsonpath_exec.c | 11 +++++++++
src/backend/utils/adt/jsonpath_gram.y | 8 +++++++
src/include/utils/jsonpath.h | 1 +
src/test/regress/expected/jsonb_jsonpath.out | 36 ++++++++++++++++++++++++++++
src/test/regress/expected/jsonpath.out | 18 ++++++++++++++
src/test/regress/sql/jsonb_jsonpath.sql | 6 +++++
src/test/regress/sql/jsonpath.sql | 3 +++
8 files changed, 85 insertions(+)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2019-06-19 19:50:50 | pgsql: pg_upgrade: Improve error messages |
| Previous Message | Peter Eisentraut | 2019-06-19 19:37:50 | pgsql: Update list of combining characters |