[EMAIL PROTECTED] wrote:
Thank you, that would answer the question. There is no "also" about it; it's exactly what I was asking all along. The conclusive answer for us would be in the C89 standard of course, where (at least in the draft that Neil quoted) I haven't been able to find anything like this. :-(
If in the future when compilers actually do begin applying aggressive enough optimization that this might be a problem in practice, it seems likely they will also have updated to C99. It seems a little much to imagine (a) a compiler that does this in the first place (b) a compiler that varies its interpretation of sequence points in an extremely subtle way depending on the dialect of C in use. IOW, I think C99 is sufficient.
-Neil ---------------------------(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