Re: proposal: jsonb_populate_array - Mailing list pgsql-hackers

Op 8/14/23 om 14:51 schreef Pavel Stehule:> po 14. 8. 2023 v 11:32
odesílatel Alvaro Herrera <alvherre@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