<entry><literal>[{"f1":1},2,null,3]</literal></entry>

</row>

<row>

<entry><para><literal>jsonb_set(target jsonb, path text[], new_value jsonb<optional>,<parameter>create_missing</parameter> <type>boolean</type></optional>)</literal>

<entry><para><literal>jsonb_set(target jsonb, path text[], new_value jsonb<optional>, create_missingboolean</optional>)</literal>

</para></entry>

<entry><para><type>jsonb</type></para></entry>

<entry>

Returns <replaceable>target</replaceable>

with the section designated by <replaceable>path</replaceable>

replaced by <replaceable>new_value</replaceable>, or with

<replaceable>new_value</replaceable> added if

<replaceable>create_missing</replaceable> is true (default is

<replaceable>create_missing</replaceable> is true (default is

<literal>true</literal>) and the item

designated by <replaceable>path</replaceable> does not exist.

As with the pathorientated operators, negative integers that

As with the pathoriented operators, negative integers that

appear in <replaceable>path</replaceable> count from the end

of JSON arrays.

</entry>

<row>

<entry>

<para><literal>

jsonb_insert(target jsonb, path text[], new_value jsonb, <optional><parameter>insert_after</parameter> <type>boolean</type></optional>)

jsonb_insert(target jsonb, path text[], new_value jsonb <optional>,insert_afterboolean</optional>)

</literal></para>

</entry>

<entry><para><type>jsonb</type></para></entry>

designated by <replaceable>path</replaceable> is in JSONB object,

<replaceable>new_value</replaceable> will be inserted only if

<replaceable>target</replaceable> does not exist. As with the path

orientated operators, negative integers that appear in

oriented operators, negative integers that appear in

<replaceable>path</replaceable> count from the end of JSON arrays.

</entry>

<entry>

<row>

<entry>

<para><literal>

jsonb_path_exists(target jsonb, path jsonpath[, vars jsonb[, silent bool]])

jsonb_path_exists(target jsonb, path jsonpath<optional>, vars jsonb<optional>, silent bool</optional></optional>)

</literal></para>

<para><literal>

jsonb_path_exists_tz(target jsonb, path jsonpath[, vars jsonb, silent bool])

jsonb_path_exists_tz(target jsonb, path jsonpath<optional>, vars jsonb <optional>, silent bool</optional></optional>)

</literal></para>

</entry>

<entry><type>boolean</type></entry>

<row>

<entry>

<para><literal>

jsonb_path_match(target jsonb, path jsonpath[, vars jsonb, silent bool])

jsonb_path_match(target jsonb, path jsonpath<optional>, vars jsonb <optional>, silent bool</optional></optional>)

</literal></para>

<para><literal>

jsonb_path_match_tz(target jsonb, path jsonpath[, vars jsonb, silent bool])

jsonb_path_match_tz(target jsonb, path jsonpath<optional>, vars jsonb <optional>, silent bool</optional></optional>)

</literal></para>

</entry>

<entry><type>boolean</type></entry>

<row>

<entry>

<para><literal>

jsonb_path_query(target jsonb, path jsonpath[, vars jsonb, silent bool])

jsonb_path_query(target jsonb, path jsonpath<optional>, vars jsonb <optional>, silent bool</optional></optional>)

</literal></para>

<para><literal>

jsonb_path_query_tz(target jsonb, path jsonpath[, vars jsonb, silent bool])

jsonb_path_query_tz(target jsonb, path jsonpath<optional>, vars jsonb <optional>, silent bool</optional></optional>)

</literal></para>

</entry>

<entry><type>setof jsonb</type></entry>

<row>

<entry>

<para><literal>

jsonb_path_query_array(target jsonb, path jsonpath[, vars jsonb, silent bool])

jsonb_path_query_array(target jsonb, path jsonpath<optional>, vars jsonb <optional>, silent bool</optional></optional>)

</literal></para>

<para><literal>

jsonb_path_query_array_tz(target jsonb, path jsonpath[, vars jsonb, silent bool])

jsonb_path_query_array_tz(target jsonb, path jsonpath<optional>, vars jsonb <optional>, silent bool</optional></optional>)

</literal></para>

</entry>

<entry><type>jsonb</type></entry>

<row>

<entry>

<para><literal>

jsonb_path_query_first(target jsonb, path jsonpath[, vars jsonb, silent bool])

jsonb_path_query_first(target jsonb, path jsonpath<optional>, vars jsonb <optional>, silent bool</optional></optional>)

</literal></para>

<para><literal>

jsonb_path_query_first_tz(target jsonb, path jsonpath[, vars jsonb, silent bool])

jsonb_path_query_first_tz(target jsonb, path jsonpath<optional>, vars jsonb <optional>, silent bool</optional></optional>)

</literal></para>

</entry>

<entry><type>jsonb</type></entry>