Re: Cast jsonb to numeric, int, float, bool

Hi Tom,
 

I can see how a cast from text can be problematic, especially before the 'unknown' type.

But what would be the scenario of failure if we have an implicit cast from jsonb datatype (that likely already parsed the number internally, or knows it holds non-numeric value) to numeric, that returns an error if it's unable to perform the conversion?

The issue I think is that jsonb is special because it is in fact container. We've got dot-notation to unpack things from composite TYPE, and we've got arrow-notation to unpack things from jsonb, but such unpacking cannot take part in further computations, even though it's visually compatible.

What would be other options, if not implicit cast?