Re: Change in 9.1? - Mailing list pgsql-sql

From Andreas Joseph Krogh
Subject Re: Change in 9.1?
Date
Msg-id 10538363.152.1321962893397.JavaMail.on@prod2
Whole thread Raw
In response to Change in 9.1?  (Jasmin Dizdarevic <jasmin.dizdarevic@gmail.com>)
List 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 by date:

Previous
From: Jasmin Dizdarevic
Date:
Subject: Change in 9.1?
Next
From: Rob Sargent
Date:
Subject: Re: Change in 9.1?