Chris,
> I've always wondered... is there some reason we don't do "type
> promotion" to match indices? So if someone provides an int, and a
> bigint index exists, it should be used automatically, as they're
> interchangable (i.e. int is a subset of bigint).
Because it's actually more difficult that it sounds.
However, we *have* made changes to 8.0 to make it better at selecting
appropriate types for constants when and index exists.
--
Josh Berkus
Aglio Database Solutions
San Francisco