Skip site navigation (1) Skip section navigation (2)

Re: index not used for boolean

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Greg Johnson <gregj(at)interprose(dot)com>
Cc: Gaetano Mendola <mendola(at)bigfoot(dot)com>, pgsql-admin(at)postgresql(dot)org
Subject: Re: index not used for boolean
Date: 2004-05-20 02:00:59
Message-ID: 200405200200.i4K20xm12757@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-admin
OK, TODO updated:

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

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

Greg Johnson wrote:
> 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

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman(at)candle(dot)pha(dot)pa(dot)us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

In response to

pgsql-admin by date

Next:From: darshan patelDate: 2004-05-20 04:44:30
Subject: To instal phpPgAdmin
Previous:From: Tom LaneDate: 2004-05-19 23:58:24
Subject: Re: Missing or errooneous pg_hba.conf file

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group