Kevin Grittner <> 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

Sent via pgsql-hackers mailing list (
To make changes to your subscription:

Reply via email to