Re: Full outer join - Mailing list pgsql-sql

From Tim Perdue
Subject Re: Full outer join
Date
Msg-id 20010413103432.C446@mail.perdue.net
Whole thread Raw
In response to Re: Full outer join  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Full outer join
List pgsql-sql
On Fri, Apr 13, 2001 at 11:11:26AM -0400, Tom Lane wrote:
> Tim Perdue <tim@perdue.net> 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


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Full outer join
Next
From: Tom Lane
Date:
Subject: Re: Full outer join