Unix Technical Forum

Re: [ANNOUNCE] =?utf-8?B?PT0=?= PostgreSQL Weekly News - June 012008 =?utf-8?B?PT0=?=

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 ...


Go Back   Unix Technical Forum > Database Server Software > PostgreSQL > pgsql Hackers

FAQ Members List Calendar Search Today's Posts Mark Forums Read
  #1 (permalink)  
Old 06-02-2008, 12:37 PM
Kaare Rasmussen
 
Posts: n/a
Default Re: [ANNOUNCE] =?utf-8?B?PT0=?= PostgreSQL Weekly News - June 012008 =?utf-8?B?PT0=?=

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

Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump


All times are GMT. The time now is 09:58 PM.


Powered by vBulletin® Version 3.6.5
Copyright ©2000 - 2008, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0
www.UnixAdminTalk.com