Horton

Support 'q' flag in jsonpath 'like_regex' predicate

Alexander Korotkov <akorotkov@postgresql.org>

View on postgr.es
Commit: 261a5c1928566f938cbda0f62dc16f6a2d1e871d
Author: Alexander Korotkov <akorotkov@postgresql.org>
Date: 2019-06-19T19:41:57Z
Releases: 12.0 
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

Files

PathChange+/−
src/backend/utils/adt/jsonpath.c modified +2 −0
src/backend/utils/adt/jsonpath_exec.c modified +11 −0
src/backend/utils/adt/jsonpath_gram.y modified +8 −0
src/include/utils/jsonpath.h modified +1 −0
src/test/regress/expected/jsonb_jsonpath.out modified +36 −0
src/test/regress/expected/jsonpath.out modified +18 −0
src/test/regress/sql/jsonb_jsonpath.sql modified +6 −0
src/test/regress/sql/jsonpath.sql modified +3 −0

Discussion