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 по дате отправления: