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