jsonpath: add like_regex support #143243
Description
Currently jsonpath does not support like_regex within predicates during evaluation. Some examples below:
norman=# SELECT jsonb_path_query('{}', 'null like_regex "^he.*$"');
jsonb_path_query
------------------
null
(1 row)
norman=# SELECT jsonb_path_query('{}', '"hello" like_regex "^he.*$"');
jsonb_path_query
------------------
true
(1 row)
norman=# SELECT jsonb_path_query('{}', '"ahello" like_regex "^he.*$"');
jsonb_path_query
------------------
false
(1 row)
Jira issue: CRDB-48721
Metadata
Metadata
Assignees
Labels
Type
Projects
Status