Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 32E094771C9 for ; Fri, 21 Jun 2002 11:33:41 -0400 (EDT) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by postgresql.org (Postfix) with ESMTP id B32FC475A75 for ; Fri, 21 Jun 2002 11:19:21 -0400 (EDT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.4/8.11.4) with ESMTP id g5LFIa119936; Fri, 21 Jun 2002 11:18:40 -0400 (EDT) To: Dirk Lutzebaeck Cc: pgsql-sql@postgresql.org Subject: Re: Optimizer question with equivalent joins In-reply-to: <15635.14203.405079.671597@cayambe.core.aeccom.com> References: <15635.14203.405079.671597@cayambe.core.aeccom.com> Comments: In-reply-to Dirk Lutzebaeck message dated "Fri, 21 Jun 2002 16:26:03 +0200" Date: Fri, 21 Jun 2002 11:18:36 -0400 Message-ID: <19933.1024672716@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200206/294 X-Sequence-Number: 8259 Dirk Lutzebaeck writes: > say I have a join which says > t.a = t.b and t.b = t.c > do I need to give the optimizer a hint by saying it more redundantly > t.a = t.b and t.b = t.c and t.c = t.a Not since about 7.0.3 ... regards, tom lane