Re: auto-casting a bit more intelligent in 8.0 ... ?

"Marc G. Fournier" <scrappy(at)postgresql(dot)org> 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