Function jsonb_array_element_str

Source
pub fn jsonb_array_element_str(
    v: JsonbRef<'_>,
    p: i32,
    writer: &mut impl Write,
) -> Option<()>
Expand description

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

jsonb ->> integer → text

§Examples

query T
select '[1,2,3]'::jsonb ->> 2;
----
3

query T
select '[1,2,null]'::jsonb ->> 2;
----
NULL