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?
--
Wells Oliver
wells(dot)oliver(at)gmail(dot)com <wellsoliver(at)gmail(dot)com>