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

2002-08-17 Thread Bruce Momjian
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 fou

[SQL] Unexplained SQL behavior

2002-08-17 Thread JOE
I am debugging a performance problem with a view.  I have narrowed down the problem to when I adeed columns to my view. In the examples below I have a view with 10 columns.  I run an explain plan and it uses the primary key of the driver table (enrollment table) as to be expected and execu

Re: [SQL] Unexplained SQL behavior

2002-08-17 Thread Tom Lane
"JOE" <[EMAIL PROTECTED]> writes: > In the examples below I have a view with 10 columns. I run an explain plan= > and it uses the primary key of the driver table (enrollment table) as to b= > e expected and executes in 1.86 msec. When I added another columns (and it= > is a null value casted t