"Lampa" <[EMAIL PROTECTED]> 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
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
