Postgres Pro
Downloads
Home   >   mailing lists

Re: Difference between is true and = 't' in boolean feild. & bitmap - Mailing list pgsql-sql

From Bruce Momjian
Subject Re: Difference between is true and = 't' in boolean feild. & bitmap
Date
Msg-id 200208171121.g7HBLKL18248@candle.pha.pa.us
Whole thread Raw
In response to Difference between is true and = 't' in boolean feild. & bitmap indexes  ("Rajesh Kumar Mallah." <mallah@trade-india.com>)
List pgsql-sql
Tree view 
Rajesh Kumar Mallah. wrote:
> 
> 
> Any can anyone explain me why in a query of a  boolean feild
> "is ture" does not indexes where as = 't' does?  is "is true"
> not a more standard SQL than " = 't' ".

Not sure.

> Also is there any working implementation of BITMAP INDEXES in
> postgresql as found in ORACLE?

We have discussed them and see a few uses for them.  See the TODO list
under Performance and there is a link to some emails discussing it.

-- 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,
Pennsylvania19073

pgsql-sql by date:

Previous
From: "Rajesh Kumar Mallah."
Date:
Subject: Difference between is true and = 't' in boolean feild. & bitmap indexes
Next
From: "JOE"
Date:
Subject: Unexplained SQL behavior