David Fetter writes:
Alter the xxx_pattern_ops opclasses to use the regular equality
operator of the associated datatype as their equality member. This
means that these opclasses can now support plain equality
comparisons along with LIKE tests, thus avoiding the need for an
extra index in some applications.
This is interesting, as it will save me a couple of very big indexes.
I didn't see that coming, but thanks.
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
