Re: BUG #4341: planner doesn't using index for = operation

"Lampa" <lampacz@gmail.com> writes:
> With varchar_pattern_ops planner is not using index(first explain) but when
> use LIKE index is used.
> I must create another index without varchar_pattern_ops flag to get equal
> speed results.

Yup, this is expected behavior because '=' is not part of the
varchar_pattern_ops operator class.

(Things will be better in 8.4, but it's not possible to fix it in
existing release branches.)

            regards, tom lane