Received: from mail.perdue.net (c696732-a.west1.ia.home.com [24.22.227.157]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f3DFa1855956 for ; Fri, 13 Apr 2001 11:36:01 -0400 (EDT) (envelope-from tperdue@mail.perdue.net) Received: (from tperdue@localhost) by mail.perdue.net (8.11.2/8.11.2/Debian 8.11.2-1) id f3DFYWX15535; Fri, 13 Apr 2001 10:34:32 -0500 Date: Fri, 13 Apr 2001 10:34:32 -0500 From: Tim Perdue To: Tom Lane Cc: Tim Perdue , pgsql-sql@postgresql.org Subject: Re: Full outer join Message-ID: <20010413103432.C446@mail.perdue.net> References: <20010412130950.O446@mail.perdue.net> <3104.987145352@sss.pgh.pa.us> <20010413082322.W446@mail.perdue.net> <3804.987174686@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.3.12i In-Reply-To: <3804.987174686@sss.pgh.pa.us>; from tgl@sss.pgh.pa.us on Fri, Apr 13, 2001 at 11:11:26AM -0400 X-Archive-Number: 200104/197 X-Sequence-Number: 2547 On Fri, Apr 13, 2001 at 11:11:26AM -0400, Tom Lane wrote: > Tim Perdue writes: > > Does it still work with those revised CREATE statements? > > Yes, works fine here. > > >> What version are you using? > > > That's RC3 and RC1. > > Curious. I'd expect this to happen for column datatypes whose '=' > operator isn't marked mergejoinable, but plain old int certainly doesn't > have that problem. I think there's something you haven't told us. Is > either of these tables actually a view? Hehe - no. I sent the \d of both tables at the bottom of that email. Tim -- Founder - PHPBuilder.com / Geocrawler.com Lead Developer - SourceForge VA Linux Systems