Re: LIKE.....and Locale - Mailing list pgsql-novice

Steve Tucknott <steve@retsol.co.uk> writes:
> The issue is under 7.4.5 the LIKE 'A%' used indexes to find data - under
> the new 8.0.3 database it doesn't. Two questions: 1) should LIKE 'A%'
> use an index under the en_US locale?

No.  See text_pattern_ops et al under
http://www.postgresql.org/docs/8.0/static/indexes-opclass.html

            regards, tom lane