"Marc G. Fournier" <[EMAIL PROTECTED]> writes: > so, its trying bigint = int, and not picking up the index ...
> the database server is 7.4.3 ... is this something that has been made a > bit more intelligent in 8.0? other then casting 0 to bigint, is there > something else I should be looking at doing? Having them go through all > of their code and casting all ints to bigint for this sounds a bit extreme > :( Yes, no, and no kidding ;-). We've been getting beat on for *years* about this behavior, but it took the proverbial Good Idea to find a workable solution. Can't generate those on a schedule I'm afraid... regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings