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(+)
