Re: database encoding with index search problem - Mailing list pgsql-performance

wisan watcharinporn wrote:
> problem:
> how can i configure database that can correct in sorting name and using
> index scan in like 'xxxx%' search

I think you'll want to read the following then have a quick search of
the mailing list archives for "opclass" for some examples.
   http://www.postgresql.org/docs/8.0/static/sql-createindex.html
   http://www.postgresql.org/docs/8.0/static/indexes-opclass.html

HTH
--
   Richard Huxton
   Archonet Ltd