On Dec 21, 2003, at 11:47 PM, Tom Lane wrote:
"Steven D.Arnold" <[EMAIL PROTECTED]> writes:Query (2) below is the same query, but we reverse the order of the tables. It's obviously not quite the same query semantically, even though in my case it should always produce the same result.
Since it is in fact not the same query, I'm unclear on why you expect it to produce the same plan.
What I expect is for both queries to use the index on the messages table! Why is it not doing that?
FWIW, I believe that 7.4 will recognize that (1) and (3) are semantically equivalent.
I will try 7.4 and report back.
steve
---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
