Re: Recursive Left Joins Causing Trouble in 8.2.3 RESOLVED (kind of)

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Recursive Left Joins Causing Trouble in 8.2.3 RESOLVED (kind of)
Дата
Msg-id 367.1172124558@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Recursive Left Joins Causing Trouble in 8.2.3 RESOLVED (kind of)  ("Ian Harding" <harding.ian@gmail.com>)
Ответы Re: Recursive Left Joins Causing Trouble in 8.2.3 RESOLVED (kind of)  ("Ian Harding" <harding.ian@gmail.com>)
Список pgsql-general
"Ian Harding" <harding.ian@gmail.com> writes:
> I had views that used syntax like
> WHERE datecol < current_date and (otherdatecol is null or otherdatecol
> > current_date)
> Suddenly, this is ungodly inefficient in 8.2.3.  It worked just fine in 8.1.3.

This complaint is pretty much content-free (especially with the oblique
implication that it's got something to do with left joins).  Please
provide a self-contained test case.

            regards, tom lane

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

Предыдущее
От: "sangeetha k.s"
Дата:
Сообщение: what compression is used in on disk bitmap index implementation
Следующее
От: "Joshua D. Drake"
Дата:
Сообщение: Re: postgresql vs mysql