Re: Implied Functional Index use

Поиск
Список
Период
Сортировка
От Zeugswetter Andreas DCP SD
Тема Re: Implied Functional Index use
Дата
Msg-id E1539E0ED7043848906A8FF995BDA579012B3EE1@m0143.s-mxs.net
обсуждение исходный текст
Ответ на Re: Implied Functional Index use  (Simon Riggs <simon@2ndquadrant.com>)
Список pgsql-hackers
> There is a problem of implication here, AFAICS:
> When a user SQL asks
>     WHERE col1 = 7
> which equality level is meant when several exist?

Well, the operator must be unique, so there is no problem.
Unique in the sense that an operator with the same name ('=' in this
case)
and argument types cannot exist for more than one level of equality.
(and the level should not have an effect on the resolution)

So, when we see col1 = 7 we lookup the equality level of the operator
and decide whether it is strict enough for the particular optimization.

Andreas


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

Предыдущее
От: Tatsuo Ishii
Дата:
Сообщение: Re: [PERFORM] Sun Donated a Sun Fire T2000 to the PostgreSQL
Следующее
От: Dave Cramer
Дата:
Сообщение: Re: postgresql.conf basic analysis tool