Re: Is index usage in LIKE-queries with UTF-8 implemented in PG-8.3 ?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Andreas Joseph Krogh <andreak(at)officenet(dot)no>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Is index usage in LIKE-queries with UTF-8 implemented in PG-8.3 ?
Date: 2007-06-28 15:54:59
Message-ID: 7483.1183046099@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Andreas Joseph Krogh <andreak(at)officenet(dot)no> writes:
> Anybody knows if queries of type "LIKE '%234%'" ever will be able to use
> indexes, and if someone is working on it?

Perhaps you are looking for full text search (contrib/tsearch2)?

regards, tom lane

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Andreas Joseph Krogh 2007-06-28 16:14:19 Re: Is index usage in LIKE-queries with UTF-8 implemented in PG-8.3 ?
Previous Message Andreas Joseph Krogh 2007-06-28 15:30:35 Re: Is index usage in LIKE-queries with UTF-8 implemented in PG-8.3 ?