Re: The type int8 and the use of indexes - Mailing list pgsql-general

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