Re: Difference between is true and = 't' in boolean feild. & bitmap

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