Skip site navigation (1)
Skip section navigation (2)
Peripheral Links
Header And Logo
|
Site Navigation
Re: Is index usage in LIKE-queries with UTF-8 implemented in PG-8.3 ?
- From: Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>
- To: Andreas Joseph Krogh <andreak(at)officenet(dot)no>
- Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-sql(at)postgresql(dot)org
- Subject: Re: Is index usage in LIKE-queries with UTF-8 implemented in PG-8.3 ?
- Date: Fri, 29 Jun 2007 11:31:09 +0400 (MSD)
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(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/ phone: +007(495)939-16-83, +007(495)939-23-83
- References:
- Is index usage in LIKE-queries with UTF-8 implemented in PG-8.3 ?
- From: Andreas Joseph Krogh
- Re: Is index usage in LIKE-queries with UTF-8 implemented in PG-8.3 ?
- From: Tom Lane
- Re: Is index usage in LIKE-queries with UTF-8 implemented in PG-8.3 ?
- From: Andreas Joseph Krogh
- Is index usage in LIKE-queries with UTF-8 implemented in PG-8.3 ?
- Prev by Date: Re: record fields as columns in reports
- Next by Date: percentages of a column
- Previous by thread: Re: Is index usage in LIKE-queries with UTF-8 implemented in PG-8.3 ?
- Next by thread: record fields as columns in reports
- Indexes: