Wells Oliver <wells.oliver@gmail.com> writes: > When I know this value is a floating point value I would just like to cast > SELECT value::real but you can't do that. You can do SELECT > (jsonbcol->>'somekey')::real, but these columns just store a value.