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?