Kevin Grittner <kgrittn@ymail.com> writes:
> It would be more consistent, ISTM, to cast
> float8 to float4 when those are compared, and to cast numeric to
> whichever type is on the other side of the comparison operator.
I would vote against that on the grounds of greatly increased risk
of overflow failure. Admittedly, numeric->float8 can also fail,
but float4 only goes to 1e37 or thereabouts.
regards, tom lane