Module jsonb_path

Statics

_LINKME_ELEMENT_jsonb_path_exists_jsonb_varchar_boolean 🔒

_LINKME_ELEMENT_jsonb_path_exists_jsonb_varchar_jsonb_boolean 🔒

_LINKME_ELEMENT_jsonb_path_exists_jsonb_varchar_jsonb_boolean_boolean 🔒

_LINKME_ELEMENT_jsonb_path_match_jsonb_varchar_boolean 🔒

_LINKME_ELEMENT_jsonb_path_match_jsonb_varchar_jsonb_boolean 🔒

_LINKME_ELEMENT_jsonb_path_match_jsonb_varchar_jsonb_boolean_boolean 🔒

_LINKME_ELEMENT_jsonb_path_query_array_jsonb_varchar_jsonb 🔒

_LINKME_ELEMENT_jsonb_path_query_array_jsonb_varchar_jsonb_boolean_jsonb 🔒

_LINKME_ELEMENT_jsonb_path_query_array_jsonb_varchar_jsonb_jsonb 🔒

_LINKME_ELEMENT_jsonb_path_query_first_jsonb_varchar_jsonb 🔒

_LINKME_ELEMENT_jsonb_path_query_first_jsonb_varchar_jsonb_boolean_jsonb 🔒

_LINKME_ELEMENT_jsonb_path_query_first_jsonb_varchar_jsonb_jsonb 🔒

_LINKME_ELEMENT_jsonb_path_query_jsonb_varchar_jsonb 🔒

_LINKME_ELEMENT_jsonb_path_query_jsonb_varchar_jsonb_boolean_jsonb 🔒

_LINKME_ELEMENT_jsonb_path_query_jsonb_varchar_jsonb_jsonb 🔒

Functions

eval_error 🔒

jsonb_path_exists2 🔒

jsonb_path_exists3 🔒

jsonb_path_exists4 🔒

Checks whether the JSON path returns any item for the specified JSON value. If the vars argument is specified, it must be a JSON object, and its fields provide named values to be substituted into the jsonpath expression. If the silent argument is specified and is true, the function suppresses the same errors as the @? and @@ operators do.

jsonb_path_exists_jsonb_varchar_boolean 🔒

jsonb_path_exists_jsonb_varchar_jsonb_boolean 🔒

jsonb_path_exists_jsonb_varchar_jsonb_boolean_boolean 🔒

jsonb_path_match2 🔒

jsonb_path_match3 🔒

jsonb_path_match4 🔒

Returns the result of a JSON path predicate check for the specified JSON value. Only the first item of the result is taken into account. If the result is not Boolean, then NULL is returned. The optional vars and silent arguments act the same as for jsonb_path_exists.

jsonb_path_match_jsonb_varchar_boolean 🔒

jsonb_path_match_jsonb_varchar_jsonb_boolean 🔒

jsonb_path_match_jsonb_varchar_jsonb_boolean_boolean 🔒

jsonb_path_query2 🔒

jsonb_path_query3 🔒

jsonb_path_query4 🔒

Returns all JSON items returned by the JSON path for the specified JSON value. The optional vars and silent arguments act the same as for jsonb_path_exists.

jsonb_path_query_array2 🔒

jsonb_path_query_array3 🔒

jsonb_path_query_array4 🔒

Returns all JSON items returned by the JSON path for the specified JSON value, as a JSON array. The optional vars and silent arguments act the same as for jsonb_path_exists.

jsonb_path_query_array_jsonb_varchar_jsonb 🔒

jsonb_path_query_array_jsonb_varchar_jsonb_boolean_jsonb 🔒

jsonb_path_query_array_jsonb_varchar_jsonb_jsonb 🔒

jsonb_path_query_first2 🔒

jsonb_path_query_first3 🔒

jsonb_path_query_first4 🔒

Returns the first JSON item returned by the JSON path for the specified JSON value. Returns NULL if there are no results. The optional vars and silent arguments act the same as for jsonb_path_exists.

jsonb_path_query_first_jsonb_varchar_jsonb 🔒

jsonb_path_query_first_jsonb_varchar_jsonb_boolean_jsonb 🔒

jsonb_path_query_first_jsonb_varchar_jsonb_jsonb 🔒

jsonb_path_query_jsonb_varchar_jsonb 🔒

jsonb_path_query_jsonb_varchar_jsonb_boolean_jsonb 🔒

jsonb_path_query_jsonb_varchar_jsonb_jsonb 🔒

parse_error 🔒