Re: Change in 9.1?

Поиск
Список
Период
Сортировка
От Andreas Joseph Krogh
Тема Re: Change in 9.1?
Дата
Msg-id 10538363.152.1321962893397.JavaMail.on@prod2
обсуждение исходный текст
Ответ на Change in 9.1?  (Jasmin Dizdarevic <jasmin.dizdarevic@gmail.com>)
Список pgsql-sql
<p>På tirsdag 22. november 2011 kl 08:39:09 skrev <strong>Jasmin Dizdarevic</strong> <<a
href="mailto:jasmin.dizdarevic@gmail.com">jasmin.dizdarevic@gmail.com</a>>:<blockquotestyle="border-left: 1px solid
rgb(204,204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"> Hi,  <div> </div><div>we have a reporting tool, that
sometimesuses this kind of condition.</div><div>...WHERE a.field = a.field </div><div> </div><div>To explain this:
a.fieldcan be filtered by the user. the user can choose some values. if he does, this condition will be
build:</div><div>...WHEREa.field IN (1,2,3)</div><div> </div><div>If the user doesn't choose any values the * = *
conditionis used.</div><div> </div><div>Since 9.1 we're experiencing problems with this construction. Have there been
anychanges to the planner regarding this?</div></blockquote><p> <p>It would be far easier to give you an answer if you
provideda query which worked before which now, in 9.1, gives you trouble.<br /><br /><span style="font-family:
monospace;font-size: 10px;">--<br /> Andreas Joseph Krogh <andreak@officenet.no> - mob: +47 909 56 963<br />
SeniorSoftware Developer / CTO - OfficeNet AS - http://www.officenet.no<br /> Public key:
http://home.officenet.no/~andreak/public_key.asc</span><p> 

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

Предыдущее
От: Jasmin Dizdarevic
Дата:
Сообщение: Change in 9.1?
Следующее
От: Rob Sargent
Дата:
Сообщение: Re: Change in 9.1?