Как преобразовать массив JSON в массив boolean?

Question

[aarifkhamdi]

value::boolean[] не работает. как сделать?

with test as
(
    SELECT key, value FROM jsonb_each('{"659": [false, false, false], "596": [true, true, true]}'::jsonb)
)
select key::integer, value::boolean[]
from test

Answer 1

[0xD34F]

SELECT key, array_agg(val)
FROM (
  SELECT key::integer, jsonb_array_elements_text(value)::boolean AS val
  FROM jsonb_each('{"659": [false, false, false], "596": [true, true, true]}'::jsonb)
) AS t
GROUP BY key

Comments

[aarifkhamdi]

благодарность, восхищение, любовь... спасибо!