"Jim C. Nasby" <[EMAIL PROTECTED]> writes: > Sure, it's just a lot of data to be shuffling around if we can avoid it. > Perhaps we could only do this if there's triggers on the table involved?
Maybe, but it's awfully late in the 8.2 cycle to be worrying about performance improvements for something that currently doesn't work at all. I'm inclined to keep it simple for now; we can revisit the issue later if anyone has problems in practice. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match