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
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
