"Daniel Podlejski" <[EMAIL PROTECTED]> writes: > I think there is no sense to cast too big value to numeric when field type > is integer. > On really big table this "bug" cause unnecessary io load.
Well, for example, the same logic doesn't hold for < where all the records would satisfy the inequality but only numeric.< will be able to handle the argument. I think you could get the behaviour you're looking for by using an untyped quoted constant like '11111111111111111111111111111111111111111111111111' instead of using an integer constant. The fact that these two cases behave differently is a bit confusing too. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's On-Demand Production Tuning -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
