Re: Full outer join

From: Tim Perdue <tim(at)perdue(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Tim Perdue <tim(at)perdue(dot)net>, pgsql-sql(at)postgresql(dot)org
Subject: Re: Full outer join
Date: 2001-04-13 15:34:32
Message-ID: 20010413103432.C446@mail.perdue.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Fri, Apr 13, 2001 at 11:11:26AM -0400, Tom Lane wrote:
> Tim Perdue <tim(at)perdue(dot)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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Tom Lane 2001-04-13 15:46:12 Re: Full outer join
Previous Message Roberto Mello 2001-04-13 15:22:37 Re: Debian Package problems