Re: [SQL] quest:optimization with indexes - Mailing list pgsql-sql

From Tom Lane
Subject Re: [SQL] quest:optimization with indexes
Date
Msg-id 9515.934410946@sss.pgh.pa.us
Whole thread Raw
In response to Re: [SQL] quest:optimization with indexes  (Clayton Cottingham <drfrog@smartt.com>)
List pgsql-sql
Clayton Cottingham <drfrog@smartt.com> writes:
> thanks for all those 'like' tips i was wonderinng, would using regex be the
> same as far as the indexing rules go?

It's equivalent --- an index can help if the pattern is anchored to the
start of the string.  Of course the pattern notation is different...
        regards, tom lane


pgsql-sql by date:

Previous
From: Clayton Cottingham
Date:
Subject: Re: [SQL] quest:optimization with indexes
Next
From: Clayton Cottingham
Date:
Subject: Re: [SQL] quest:optimization with indexes