pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedindex not used for boolean
3+ messages / 3 participants
[nested] [flat]
* index not used for boolean
@ 2004-05-04 07:04 Gaetano Mendola <mendola@bigfoot.com>
0 siblings, 1 reply; 3+ messages in thread
From: Gaetano Mendola @ 2004-05-04 07:04 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: index not used for boolean
@ 2004-05-04 14:31 Greg Johnson <gregj@interprose.com>
parent: Gaetano Mendola <mendola@bigfoot.com>
0 siblings, 1 reply; 3+ messages in thread
From: Greg Johnson @ 2004-05-04 14:31 UTC (permalink / raw)
To: Gaetano Mendola <mendola@bigfoot.com>; +Cc: 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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: index not used for boolean
@ 2004-05-20 02:00 Bruce Momjian <pgman@candle.pha.pa.us>
parent: Greg Johnson <gregj@interprose.com>
0 siblings, 0 replies; 3+ messages in thread
From: Bruce Momjian @ 2004-05-20 02:00 UTC (permalink / raw)
To: Greg Johnson <gregj@interprose.com>; +Cc: Gaetano Mendola <mendola@bigfoot.com>; 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@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2004-05-20 02:00 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-05-04 07:04 index not used for boolean Gaetano Mendola <mendola@bigfoot.com>
2004-05-04 14:31 ` Greg Johnson <gregj@interprose.com>
2004-05-20 02:00 ` Bruce Momjian <pgman@candle.pha.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox