Kevin Grittner <kgri...@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 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers