Thread: pgsql: Support 'q' flag in jsonpath 'like_regex' predicate
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(+)