"Hamby, Mark CONTRACTOR HAMBYM" <MARK(dot)HAMBY(at)LEAVENWORTH(dot)ARMY(dot)MIL> writes:
> /* QUERY WITH EXPLICIT TIMESTAMP CONVERSION */
> /* DOES NOT USE INDEX AND IS VERY SLOW. */
> /* DOES ANYONE CARE? */
Nope.
> explain analyze
> select count(*)
> from truth_units
> where time = timestamp '2002-08-15 10:00'
> ;
"timestamp" is "timestamp with time zone" in 7.2. So this is an
unindexable cross-datatype comparison.
regards, tom lane