Re: Re: 9.2.4: Strange behavior when wildcard is on left side of search string

From: Kevin Grittner <kgrittn(at)ymail(dot)com>
To: David Johnston <polobo(at)yahoo(dot)com>, "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: Re: 9.2.4: Strange behavior when wildcard is on left side of search string
Date: 2013-04-07 13:52:08
Message-ID: 1365342728.67050.YahooMailNeo@web162902.mail.bf1.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

David Johnston <polobo(at)yahoo(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message ERR ORR 2013-04-07 14:45:49 Re: Re: 9.2.4: Strange behavior when wildcard is on left side of search string
Previous Message David Johnston 2013-04-07 01:19:21 Re: 9.2.4: Strange behavior when wildcard is on left side of search string