Skip site navigation (1) Skip section navigation (2)

Re: Outer join differences

From: Thomas Lockhart <lockhart(at)fourpalms(dot)org>
To: Yuva Chandolu <ychandolu(at)ebates(dot)com>
Cc: 'Stephan Szabo' <sszabo(at)megazone23(dot)bigpanda(dot)com>,"'pgsql-hackers(at)postgresql(dot)org'" <pgsql-hackers(at)postgresql(dot)org>,"'chriskl(at)familyhealth(dot)com(dot)au'" <chriskl(at)familyhealth(dot)com(dot)au>
Subject: Re: Outer join differences
Date: 2002-07-31 06:18:41
Message-ID: 3D478141.3B97CFE3@fourpalms.org (view raw or flat)
Thread:
Lists: pgsql-hackers
> This is great, we thought we may go for code changes, we will go with this
> solution instead.

But you did catch Stephan's point that an outer join is not required to
produce the result you apparently want? The equivalent inner join will
be at worst just as fast, and possibly faster, both for PostgreSQL and
for Oracle...

                  - Thomas

In response to

pgsql-hackers by date

Next:From: Curt SampsonDate: 2002-07-31 06:23:43
Subject: Re: Why is MySQL more chosen over PostgreSQL?
Previous:From: Tom LaneDate: 2002-07-31 06:17:50
Subject: Re: Why is MySQL more chosen over PostgreSQL?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group