Rod Taylor <[EMAIL PROTECTED]> writes: > Indeed. At the INNER JOIN it would appear that an alias is applied to > the columns of a given table. > ... > The real trick is to make INNER JOINS less greedy in their requirements > based on the columns that are actually used.
What surprised me about this report was not that the JOIN syntax exposed a dependency on column c, but that the non-JOIN syntax didn't. There shouldn't be any semantic difference AFAIR, so it seems to me that at least one of these behaviors needs to be fixed. I am not sure that it's practical to remove the dependency as Tim is hoping for... regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster