Received: from sss.pgh.pa.us ([192.204.191.242]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fA7J6Am18427 for ; Wed, 7 Nov 2001 14:06:10 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) 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 fA7J68c05791; Wed, 7 Nov 2001 14:06:08 -0500 (EST) To: nickf@ontko.com cc: "PGSQL-SQL" Subject: Re: RIGHT JOIN is only supported with mergejoinable join conditions In-reply-to: References: Comments: In-reply-to "Nick Fankhauser" message dated "Wed, 07 Nov 2001 11:16:38 -0500" Date: Wed, 07 Nov 2001 14:06:08 -0500 Message-ID: <5788.1005159968@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200111/113 X-Sequence-Number: 5497 "Nick Fankhauser" writes: > and > ( > local_case_type.local_case_subtype_code = > case_data.local_case_type_code > ) Did you actually mean to match local_case_subtype_code against local_case_type_code, or is that a typo? I believe you have uncovered a planner bug, but the bug may be triggered by the partial overlap of this join condition with the next one. Assuming that it's a typo, you may find that you avoid the problem by fixing the typo. regards, tom lane