Home > mailing lists

Malformed array literal in goin from jsonb to real[] - Mailing list pgsql-admin

From	Wells Oliver
Subject	Malformed array literal in goin from jsonb to real[]
Date	March 9, 2023 18:19:59
Msg-id	CAOC+FBWKkoHWmCu+RtkTcJ76FkeqaNTSuPVtzvp=SBK6xbv+kQ@mail.gmail.com Whole thread Raw
Responses	Re: Malformed array literal in goin from jsonb to real[] (Erik Wienhold <ewie@ewie.name>)
List	pgsql-admin

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 some awful string munging?

From: Tom Lane
Date: 09 March 2023, 17:35:49
Subject: Re: database collation "C" and "C.LATIN1"

From: Erik Wienhold
Date: 09 March 2023, 19:05:56
Subject: Re: Malformed array literal in goin from jsonb to real[]