X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 982309DCA1E for ; Sun, 15 Jan 2006 19:21:53 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 81680-05 for ; Sun, 15 Jan 2006 19:21:55 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey- Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by postgresql.org (Postfix) with ESMTP id 2526A9DCA0B for ; Sun, 15 Jan 2006 19:21:50 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id k0FNLrVV024300; Sun, 15 Jan 2006 18:21:53 -0500 (EST) To: "Dean Gibson (DB Administrator)" cc: pgsql-sql Subject: Re: What does "merge-joinable join conditions" mean ???? In-reply-to: <43CACC78.7090107@ultimeth.com> References: <43CAAFA6.6050001@ultimeth.com> <20060115215448.GA30809@winnie.fuhr.org> <43CACC78.7090107@ultimeth.com> Comments: In-reply-to "Dean Gibson (DB Administrator)" message dated "Sun, 15 Jan 2006 14:28:08 -0800" Date: Sun, 15 Jan 2006 18:21:53 -0500 Message-ID: <24299.1137367313@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.089 required=5 tests=[AWL=0.089] X-Spam-Score: 0.089 X-Spam-Level: X-Archive-Number: 200601/83 X-Sequence-Number: 23872 "Dean Gibson (DB Administrator)" writes: > SELECT count(*) FROM "GenAppExtra" FULL JOIN "GeoRestrict" ON callsign > ~ pattern WHERE region_id = 4 OR geo_region = 4; > If either of the "region_id = 4" (a field in the right-hand table) or > "geo_region = 4" (a field in the left-hand table) are removed, the > SELECT functions (does not give an error message), Really? The FULL JOIN condition using ~ is the source of the failure, and I'd be quite surprised if changing WHERE makes it work. regards, tom lane