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
Currently jsonpath does not support
like_regexwithin predicates during evaluation. Some examples below:Jira issue: CRDB-48721