Malformed array literal in goin from jsonb to real[]

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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?

--

[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux