Re: Badly planned queries with JOIN syntax

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Phil Mayers <p(dot)mayers(at)imperial(dot)ac(dot)uk>
Cc: pgsql <pgsql-general(at)postgresql(dot)org>
Subject: Re: Badly planned queries with JOIN syntax
Date: 2003-04-04 16:50:33
Message-ID: 7331.1049475033@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Phil Mayers <p(dot)mayers(at)imperial(dot)ac(dot)uk> writes:
> Put another way - I *don't* want to use the order of the JOINs as an
> explicit command to the planner, but *do* need to use the JOIN syntax
> since I need OUTER and FULL joins in some or all queries (which you
> can's specify with WHERE).

This behavior has been changed for 7.4, but there isn't much to be done
about it in 7.3, unless you want to try to back-port the relevant fixes.

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message nolan 2003-04-04 16:56:12 Converting from dbase
Previous Message Jeffrey D. Brower 2003-04-04 16:42:33 Re: OSS database needed for testing