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