On Fri, Dec 12, 2014 at 6:44 PM, Tom Lane <t...@sss.pgh.pa.us> wrote: > The usability issue could be fixed by teaching the planner to fold a > construct like (jsonb ->> 'foo')::numeric into (jsonb ->># 'foo'). > But I'm not sure how we do that except in a really ugly and ad-hoc > fashion.
It would be doable if you could have polymorphism on return type, and teach the planner to interpret (jsonb ->> 'foo')::numeric as the operator with a numeric return type. That's a trickier business even, but it could be far more useful and generically helpful than ->>#. Tricky part is what to do when the cast is missing. -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
