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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-hackers by date

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