Change in 9.1?

From: Jasmin Dizdarevic <jasmin(dot)dizdarevic(at)gmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Change in 9.1?
Date: 2011-11-22 07:39:09
Message-ID: CAOveQuPRqy0NoJkNFMRAhkJoWoc8jHSMz8fKdf56Xjzz5Gw27A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Andreas Joseph Krogh 2011-11-22 11:54:53 Re: Change in 9.1?
Previous Message Jasen Betts 2011-11-16 18:49:08 Re: updating a sequence