Change in 9.1?

Поиск
Список
Период
Сортировка
От Jasmin Dizdarevic
Тема Change in 9.1?
Дата
Msg-id CAOveQuPRqy0NoJkNFMRAhkJoWoc8jHSMz8fKdf56Xjzz5Gw27A@mail.gmail.com
обсуждение исходный текст
Ответы Re: Change in 9.1?  (Andreas Joseph Krogh <andreak@officenet.no>)
Re: Change in 9.1?  (Rob Sargent <robjsargent@gmail.com>)
Список pgsql-sql
Hi, 

we have a reporting tool, that sometimes uses this kind of condition.
...WHERE a.field = a.field 

To explain this: a.field can be filtered by the user. the user can choose some values. if he does, this condition will be build:
...WHERE a.field IN (1,2,3)

If the user doesn't choose any values the * = * condition is used.

Since 9.1 we're experiencing problems with this construction. Have there been any changes to the planner regarding this?

Ty
Regards, Jasmin

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

Предыдущее
От: Jasen Betts
Дата:
Сообщение: Re: updating a sequence
Следующее
От: Andreas Joseph Krogh
Дата:
Сообщение: Re: Change in 9.1?