Wells Oliver <wells.oliver@gmail.com> writes: > Well, it's because the representation of the value is getting double > quoted, so it's > select '"1.453"'::real, which yields ERROR: cannot cast jsonb string to > type real.
Oh ... that perhaps wasn't a great choice. But it looks like you could pretend the jsonb is a 1-element array, and do