index not used for boolean - Mailing list pgsql-admin

From Gaetano Mendola
Subject index not used for boolean
Date
Msg-id c77fad$qru$1@floppy.pyrenet.fr
Whole thread Raw
Responses Re: index not used for boolean  (Greg Johnson <gregj@interprose.com>)
List pgsql-admin
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

pgsql-admin by date:

Previous
From: douglas morrison
Date:
Subject: Re: Bad character data
Next
From: "Noah Davis"
Date:
Subject: Re: Bad character data