index not used for boolean

[Gaetano Mendola]

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

[Greg Johnson]

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.

Post by Gaetano Mendola
Hi all,
select * from foo where expired;
the index on expired is not used?
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

[Bruce Momjian]

OK, TODO updated:

* Allow col IS TRUE/FALSE use an index like col = TRUE/FALSE

---------------------------------------------------------------------------

Post by Greg Johnson
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.

Post by Gaetano Mendola
Hi all,
select * from foo where expired;
the index on expired is not used?
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