Module jsonb_access

Statics

_LINKME_ELEMENT_jsonb_access_jsonb_int4_jsonb 🔒

_LINKME_ELEMENT_jsonb_access_jsonb_varchar_jsonb 🔒

_LINKME_ELEMENT_jsonb_access_str_jsonb_int4_varchar 🔒

_LINKME_ELEMENT_jsonb_access_str_jsonb_varchar_varchar 🔒

_LINKME_ELEMENT_jsonb_extract_path_jsonb_variadic_jsonb 🔒

_LINKME_ELEMENT_jsonb_extract_path_text_jsonb_variadic_varchar 🔒

_LINKME_ELEMENT_jsonb_extract_path_text_variadic_jsonb_varchararray_varchar 🔒

_LINKME_ELEMENT_jsonb_extract_path_variadic_jsonb_varchararray_jsonb 🔒

Functions

jsonb_access_jsonb_int4_jsonb 🔒

jsonb_access_jsonb_varchar_jsonb 🔒

jsonb_access_str_jsonb_int4_varchar 🔒

jsonb_access_str_jsonb_varchar_varchar 🔒

jsonb_array_element

Extracts n’th element of JSON array (array elements are indexed from zero, but negative integers count from the end).

jsonb_array_element_str

Extracts n’th element of JSON array, as text.

jsonb_extract_path

Extracts JSON sub-object at the specified path, where path elements can be either field keys or array indexes.

jsonb_extract_path_jsonb_variadic_jsonb 🔒

jsonb_extract_path_text

Extracts JSON sub-object at the specified path as text.

jsonb_extract_path_text_jsonb_variadic_varchar 🔒

jsonb_extract_path_text_variadic_jsonb_varchararray_varchar 🔒

jsonb_extract_path_variadic_jsonb_varchararray_jsonb 🔒

jsonb_object_field

Extracts JSON object field with the given key.

jsonb_object_field_str

Extracts JSON object field with the given key, as text.