jsonb_array_elements
jsonb_array_elements_text
jsonb_array_length
jsonb_build_array
to_jsonb
.
jsonb_build_object
to_jsonb
.
jsonb_each
jsonb_each_text
jsonb_extract_path
from_json
is the input JSON value from which to extract the sub-object.path_elems
is the path elements that specify the location of the desired sub-object in the JSON structure. Multiple path elements can be provided as separate arguments.jsonb_extract_path_text
jsonb_object_keys
jsonb_strip_nulls
jsonb_path_exists
vars
argument is provided, it must be a JSON object. Its fields act as named values that are substituted into the path
expression. When the silent
argument is specified and set to true
, the function will suppress errors like the @? and @@ operators.
For information on the SQL/JSON Path syntax, refer to the PostgreSQL documentation.
jsonb_path_match
jsonb_path_query
jsonb_path_query_array
jsonb_path_query_first
jsonb_populate_record
NULL
, meaning that any output columns that do not match any object field will be NULL
. Otherwise, values in the base are used for unmatched columns.
The conversion of JSON values to SQL types of the output column applies these rules in sequence:
jsonb_populate_record
function in RisingWave differs from the function in PostgreSQL. In PostgreSQL, users are required to define a composite type using the CREATE TYPE
statement before using these functions. However, in RisingWave, you should use the inline struct type instead.jsonb_populate_recordset
jsonb_populate_recordset
function in RisingWave differs from the function in PostgreSQL. In PostgreSQL, users are required to define a composite type using the CREATE TYPE
statement before using these functions. However, in RisingWave, you should use the inline struct type instead.jsonb_populate_map
jsonb
data into a map
type by merging key-value pairs from the jsonb
into the specified map
.
jsonb_set
create_if_missing
parameter is set to true
(which is the default), the function will add the new value.
jsonb_typeof
jsonb_pretty
jsonb
value and returns a text representing the formatted, indented JSON value.
jsonb_object
jsonb
object where adjacent pairs of values are taken as the key and value of an object property.
to_jsonb
jsonb -> integer → jsonb
jsonb -> varchar → jsonb
jsonb ->> integer → varchar
jsonb ->> varchar → varchar
jsonb - text → jsonb
jsonb - text[] → jsonb
jsonb - integer → jsonb
jsonb #- text[] → jsonb
(jsonb || jsonb) → jsonb
jsonb @> jsonb → boolean
jsonb
value contains the right jsonb
value. For a detailed description and examples about containment and existence, see jsonb Containment and Existence in PostgreSQL’s documentation.
jsonb <@ jsonb → boolean
jsonb
value is contained within the right jsonb
value. For a detailed description and examples about containment and existence, see jsonb Containment and Existence in PostgreSQL’s documentation.
jsonb ? text → boolean
jsonb
value.
jsonb ?| text[] → boolean
jsonb
value.
json ?& text[] → boolean
jsonb
value.
jsonb #> text[] → jsonb
jsonb #>> text[] → text
jsonb @? varchar → boolean
jsonb @@ varchar → boolean
IS JSON
predicate