"Tom Lane" <[EMAIL PROTECTED]> writes: > Gregory Stark <[EMAIL PROTECTED]> writes: >> I believe this is happening because the numeric is being cast to float8 and >> then the float4-float8 cross-data-type operator is being used. It seems like >> it would be preferable to cast it to float4 and use the non-cross-data-type >> operator. They're both marked as implicit casts so I'm unclear what decides >> which gets used. > > Without having traced through the code, I think the fact that float8 is > a "preferred type" is driving it. It's not clear whether we could > change this without getting into a "can't resolve ambiguous operator" > problem.
This is pre-operator-families, I thought "preferred type" was new with them. Perhaps we should have preferred operators rather than preferred types? -- Gregory Stark EnterpriseDB http://www.enterprisedb.com ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq
