Re: index not used for boolean

From: Greg Johnson <gregj(at)interprose(dot)com>
To: Gaetano Mendola <mendola(at)bigfoot(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: index not used for boolean
Date: 2004-05-04 14:31:42
Message-ID: 1083681101.24739.21.camel@watto.interprose.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I just ran into this yesterday also. I was trying
select * from foo where expired IS TRUE
and the index was not used, but when I switched it to expired = true it
worked... Very frustrating bug.. wasted about 3 hours planning and
analyzing the simple query.

On Tue, 2004-05-04 at 00:04, Gaetano Mendola wrote:

> Hi all,
> is it normal that in a select like:
>
> select * from foo where expired;
>
> the index on expired is not used?
>
> If I rewrite that query:
>
> select * from foo where expired = true;
>
> then the index is used!
>
> I'm using postrgres 7.4.2
>
>
> Regards
> Gaetano Mendola
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://archives.postgresql.org

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message douglas morrison 2004-05-04 14:33:39 Re: Bad character data
Previous Message Noah Davis 2004-05-04 14:09:19 Re: Bad character data