Re: Badly planned queries with JOIN syntax

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Badly planned queries with JOIN syntax
Дата
Msg-id 7331.1049475033@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Badly planned queries with JOIN syntax  (Phil Mayers <p.mayers@imperial.ac.uk>)
Список pgsql-general
Phil Mayers <p.mayers@imperial.ac.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


В списке pgsql-general по дате отправления:

Предыдущее
От: "Ed L."
Дата:
Сообщение: Re: dbmirror revisions
Следующее
От: nolan@celery.tssi.com
Дата:
Сообщение: Converting from dbase