Postgres Pro
Downloads
Home   >   mailing lists

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

From Tom Lane
Subject Re: Is index usage in LIKE-queries with UTF-8 implemented in PG-8.3 ?
Date
Msg-id 7483.1183046099@sss.pgh.pa.us
Whole thread Raw
In response to Re: Is index usage in LIKE-queries with UTF-8 implemented in PG-8.3 ?  (Andreas Joseph Krogh <andreak@officenet.no>)
Responses Re: Is index usage in LIKE-queries with UTF-8 implemented in PG-8.3 ?  (Andreas Joseph Krogh <andreak@officenet.no>)
List pgsql-sql
Tree view 
Andreas Joseph Krogh <andreak@officenet.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

pgsql-sql by date:

Previous
From: Andreas Joseph Krogh
Date:
Subject: Re: Is index usage in LIKE-queries with UTF-8 implemented in PG-8.3 ?
Next
From: Andreas Joseph Krogh
Date:
Subject: Re: Is index usage in LIKE-queries with UTF-8 implemented in PG-8.3 ?