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 Oleg Bartunov
Subject Re: Is index usage in LIKE-queries with UTF-8 implemented in PG-8.3 ?
Date
Msg-id Pine.LNX.4.64.0706291126241.1881@sn.sai.msu.ru
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>)
List pgsql-sql
Tree view 
On Thu, 28 Jun 2007, Andreas Joseph Krogh wrote:

> Anybody knows if queries of type "LIKE '%234%'" ever will be able to use
> indexes, and if someone is working on it? I'm sure I'm not the only one who
> would very much appreciate it:-)
>

This is quite easily could be done with tsearch using substring dictionary.
Search archives !
    Regards,        Oleg
_____________________________________________________________
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: oleg@sai.msu.su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83

pgsql-sql by date:

Previous
From: "A. Kretschmer"
Date:
Subject: Re: record fields as columns in reports
Next
From: Andreas
Date:
Subject: percentages of a column