Re: Malformed array literal in goin from jsonb to real[]

> On 09/03/2023 16:19 CET Wells Oliver <wells(dot)oliver(at)gmail(dot)com> wrote:
>
> This value exists in my jsonb column:
>
> [[-0.7452975, -0.21457797, 0.631259], [0.66549873, -0.2969812, 0.6847727], [0.04053491, 0.9304614, 0.3641407]]
>
> Which obviously blows up when doing (jsonb->>col)::real[] with malformed
> array literal.
>
> Is there a convenient function to do this casting or do I need to do somes
> awful string munging?

Use jsonb_populate_record with a custom type:

create type myrec as (col real[][]);

select * from jsonb_populate_record(null::myrec, '{"col":[[0,1],[2,3]]}');

col
---------------
{{0,1},{2,3}}
(1 row)

--
Erik