Re: Attempt at work around of int4 query won't touch int8 index ...

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Attempt at work around of int4 query won't touch int8 index ...
Дата
Msg-id 20901.1063248257@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Attempt at work around of int4 query won't touch int8 index ...  (James Robinson <jlrobins@socialserve.com>)
Ответы Re: Attempt at work around of int4 query won't touch int8 index ...  ("Shridhar Daithankar" <shridhar_daithankar@persistent.co.in>)
Список pgsql-performance
James Robinson <jlrobins@socialserve.com> writes:
> Is this just a dead end, or is there some variation of this that might
> possibly work, so that ultimately an undoctored literal number, when
> applied to an int8 column, could find an index?

I think it's a dead end.  What I was playing with this afternoon was
removing the int8-and-int4 comparison operators from pg_operator.
It works as far as making "int8col = 42" do the right thing, but I'm
not sure yet about side-effects.

            regards, tom lane

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

Предыдущее
От: James Robinson
Дата:
Сообщение: Attempt at work around of int4 query won't touch int8 index ...
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: Reading data in bulk - help?