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
