Received: from shire.ontko.com (shire.ontko.com [199.164.165.1]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fA7IVgm17005 for ; Wed, 7 Nov 2001 13:31:42 -0500 (EST) (envelope-from nickf@ontko.com) Received: from nick (bilbo.ontko.com [199.164.165.101]) by shire.ontko.com (8.9.3/8.9.3/Debian 8.9.3-21) with SMTP id NAA28490; Wed, 7 Nov 2001 13:31:34 -0500 X-Authentication-Warning: shire.ontko.com: Host bilbo.ontko.com [199.164.165.101] claimed to be nick Reply-To: From: "Nick Fankhauser" To: "Tom Lane" Cc: "PGSQL-SQL" Subject: Re: RIGHT JOIN is only supported with mergejoinable join conditions Date: Wed, 7 Nov 2001 13:29:44 -0500 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0) In-reply-to: <5273.1005154723@sss.pgh.pa.us> X-MIMEOLE: Produced By Microsoft MimeOLE V5.00.2919.6600 Importance: Normal X-Archive-Number: 200111/112 X-Sequence-Number: 5496 They are all varchar. -Nick > > RIGHT JOIN is only supported with mergejoinable join conditions > > What are the datatypes of the columns you're using? > > regards, tom lane >