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 F3E679DC854 for ; Sun, 15 Jan 2006 17:58:29 -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 64202-10 for ; Sun, 15 Jan 2006 17:58:30 -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 0502E9DC88E for ; Sun, 15 Jan 2006 17:58:26 -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 k0FLwSoP017051; Sun, 15 Jan 2006 16:58:28 -0500 (EST) To: "Dean Gibson (DB Administrator)" cc: pgsql-sql Subject: Re: What does "merge-joinable join conditions" mean ???? In-reply-to: <43CAAFA6.6050001@ultimeth.com> References: <43CAAFA6.6050001@ultimeth.com> Comments: In-reply-to "Dean Gibson (DB Administrator)" message dated "Sun, 15 Jan 2006 12:25:10 -0800" Date: Sun, 15 Jan 2006 16:58:28 -0500 Message-ID: <17050.1137362308@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/80 X-Sequence-Number: 23869 "Dean Gibson (DB Administrator)" writes: > I have a FULL JOIN between two simple tables, and am getting the message > " Query failed: ERROR: FULL JOIN is only supported with merge-joinable > join conditions" > I'd be glad to fix this in my query if I knew what the #@!! it meant. The join condition(s) of a FULL JOIN have to be mergejoinable, which basically means an equality relation between sortable (btree-indexable) data types. You can see exactly which operators are mergejoinable with a query like select oid::regoperator from pg_operator where oprlsortop != 0; regards, tom lane