[ https://issues.jboss.org/browse/TEIID-5481?page=com.atlassian.jira.plugin... ] Steven Hawkins edited comment on TEIID-5481 at 5/22/19 8:24 AM: ---------------------------------------------------------------- There will be two functions: jsonquery(json|clob, jsonPath [, null_for_missing]) returns json - roughly the same functionality as xmlquery. jsonpathvalue(json|clob, jsonPath [, null_for_missing]) returns string - roughly the same functionality as xpathvalue (returns a string value of a single item) Neither quite match the semantics of the pg logic, but will be familiar to those who know jsonpath. The jayway implementation uses 0-based indexing - which does not seem to be consistent across implementations. was (Author: shawkins): There will be two functions: jsonquery(json, jsonPath) returns json - roughly the same functionality as xmlquery. jsonpathvalue(json, jsonPath) returns string - roughly the same functionality as xpathvalue (returns a string value of a single item) Neither quite match the semantics of the pg logic, but will be familiar to those who know jsonpath. The jayway implementation uses 0-based indexing - which does not seem to be consistent across implementations. -- This message was sent by Atlassian Jira (v7.12.1#712002)