Re: proposal: jsonb_populate_array

[Erik Rijkers]

Op 8/14/23 om 14:51 schreef Pavel Stehule:> po 14. 8. 2023 v 11:32 
odesílatel Alvaro Herrera <alvhe...@alvh.no-ip.org>
> with proposed function I can write
>
> select jsonb_populate_array(null:date[],
> '["2023-07-13","2023-07-14"]'::jsonb)
>
Not yet committed, but outstanding
SQL/JSON patches (v11) will let you do:
select json_query(
    '["2023-07-13", "2023-07-14"]'::jsonb
  , '$' returning date[]
);
       json_query
-------------------------
 {2023-07-13,2023-07-14}
(1 row)

That's (more or less) what you want, no?

Let's hope it gets submitted 17-ish, anyway

Erik