Re: jsonb_array_elements_recursive()

From: "Joel Jacobson" <joel(at)compiler(dot)org>
To: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: Re: jsonb_array_elements_recursive()
Date: 2021-02-07 15:59:04
Message-ID: 82309d63-eb84-4bb7-a387-e76e8ca265fd@www.fastmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Having thought about this some more,
the function name should of course be jsonb_unnest(),
similar to how unnest() works for normal arrays:

SELECT unnest(array[[3,2],[1,4]]);
unnest
--------
3
2
1
4
(4 rows)

SELECT jsonb_unnest('[[3,2],[1,4]]'::jsonb);
jsonb_unnest
--------------------
3
2
1
4
(4 rows)

Thoughts?

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Pavel Stehule 2021-02-07 16:08:46 Re: jsonb_array_elements_recursive()
Previous Message Bruce Momjian 2021-02-07 14:50:14 Re: Prevent printing "next step instructions" in initdb and pg_upgrade