David Johnston <pol...@yahoo.com> wrote:

> varchar(100)

> The other option to index words via the full-text search capabilities.

Or for columns this short,  a similarity search on a trigram index.

http://www.postgresql.org/docs/current/interactive/pgtrgm.html

--
Kevin Grittner
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

Reply via email to