| 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: | Whole Thread | Raw Message | 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
| 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? |