This is a discussion on Re: [ANNOUNCE] =?utf-8?B?PT0=?= PostgreSQL Weekly News - June 012008 =?utf-8?B?PT0=?= within the pgsql Hackers forums, part of the PostgreSQL category; --> David Fetter writes: > Alter the xxx_pattern_ops opclasses to use the regular equality > operator of the associated datatype ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| 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 |