On Mon, Mar 08, 2004 at 11:05:25 -0500, Andrew Sullivan <[EMAIL PROTECTED]> wrote: > > "Intended", no. "Expected", yes. This topic has had the best > Postgres minds work on it, and so far nobody's come up with a > solution. There was a proposal to put in a special-case automatic > fix for int4/int8 in 7.4, but I don't know whether it made it in.
This is handled better in 7.5. Instead of doing things deciding what types of type conversion to do, a check is make for cross type conversion functions that could be used for an index scan. This is a general solution that doesn't result in unexpected type conversions. ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings