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
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 |