Cross-datatype Comparisons and Indexes

Поиск
Список
Период
Сортировка
От Thomas F.O'Connell
Тема Cross-datatype Comparisons and Indexes
Дата
Msg-id 56B36E80-F2E9-11D8-9218-000D93AE0944@sitening.com
обсуждение исходный текст
Ответы Re: Cross-datatype Comparisons and Indexes  (Bruno Wolff III <bruno@wolff.to>)
Re: Cross-datatype Comparisons and Indexes  (Mike Mascari <mascarm@mascari.com>)
Список pgsql-general
Since the current stable version of postgres (7.4.x) doesn't allow
cross-datatype comparisons of indexes, is it always necessary to cast
my application data explicitly in order for an index to be used, even
among the integer types?

E.g., If I have a table with a bigint primary key and application data
compared against that primary key, must I always explicitly cast the
application data to bigint if I want postgres to use the index?

SELECT * FROM some_table WHERE primary_key_column = 42

vs.

SELECT * FROM some_table WHERE primary_key_column = 42::int8

There's no way to tell postgres to treat incoming data implicitly as
the type of the column, right?

Thanks!

-tfo


В списке pgsql-general по дате отправления:

Предыдущее
От: "Dann Corbit"
Дата:
Сообщение: Re: Help with optimizing query
Следующее
От: Bruno Wolff III
Дата:
Сообщение: Re: Cross-datatype Comparisons and Indexes