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. 

In response to

• == PostgreSQL Weekly News - June 01 2008 == at 2008-06-01 23:33:55 from David Fetter

pgsql-announce by date

Next:	From: John DeSoi	Date: 2008-06-03 00:43:19
	Subject: pgEdit 1.4 released
Previous:	From: Ishikawa Toshiyuki	Date: 2008-06-02 02:53:42
	Subject: JPUG Conference 2008 in Tokyo

pgsql-hackers by date

Next:	From: Dawid Kuroczko	Date: 2008-06-02 10:09:19
	Subject: Re: [0/4] Proposal of SE-PostgreSQL patches
Previous:	From: Dave Page	Date: 2008-06-02 07:37:36
	Subject: Re: Overhauling GUCS