on Jan 25, 2001, 15:14, Stephan Szabo std::cout'ed:
[snip]
| select * from table where pk=1::int8 should use the index if pk is an
| int8 column.
Would that work for other operators (such as <, >, etc.) as well? Last
time I tried something similar on Postgres-7.0.2, the index was used on
equality but not on "less-than" (the number of rows in the result was very
small).
ivr
--
Everybody has to have a philosophy. Some people believe in laissez
faire economics, others believe in reincarnation. Some people even
believe that COBOL is a real programming language.
S. Meyers, "Effective C++", item 26