On 2/21/07, Tom Lane <[EMAIL PROTECTED]> wrote:
"Ian Harding" <[EMAIL PROTECTED]> writes:
> I had views that used syntax like
> WHERE datecol < current_date and (otherdatecol is null or otherdatecol
> > current_date)
> Suddenly, this is ungodly inefficient in 8.2.3. It worked just fine in 8.1.3.
"Ian Harding" <[EMAIL PROTECTED]> writes:
> I had views that used syntax like
> WHERE datecol < current_date and (otherdatecol is null or otherdatecol
> > current_date)
> Suddenly, this is ungodly inefficient in 8.2.3. It worked just fine in 8.1.3.
This complaint is pretty much content-free (espe
OK, here's the deal
I had views that used syntax like
WHERE datecol < current_date and (otherdatecol is null or otherdatecol
current_date)
Kind of a hillbilly version of BETWEEN but it assumes null is INFINITY
(except I use date, not timestamp)
Suddenly, this is ungodly inefficient in 8.2.3.
OK, here's the deal
I had views that used syntax like
WHERE datecol < current_date and (otherdatecol is null or otherdatecol
current_date)
Kind of a hillbilly version of BETWEEN but it assumes null is INFINITY
(except I use date, not timestamp)
Suddenly, this is ungodly inefficient in 8.2.3.
