Received: from sss.pgh.pa.us ([192.204.191.242]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fA7Hclm14847 for ; Wed, 7 Nov 2001 12:38:47 -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 fA7Hcic05276; Wed, 7 Nov 2001 12:38:44 -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 12:38:43 -0500 Message-ID: <5273.1005154723@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200111/110 X-Sequence-Number: 5494 "Nick Fankhauser" writes: > I'm on version 7.1, and I'm getting this error when attempting to select > from a view: > RIGHT JOIN is only supported with mergejoinable join conditions What are the datatypes of the columns you're using? regards, tom lane