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: 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: Thu, 28 Jun 2007 11:20:56 -0400
Andreas Joseph Krogh <andreak(at)officenet(dot)no> writes: > Anybody knows if the following query will use an index-scan in PG-8.3? > SELECT name FROM person WHERE name LIKE 'and%'; > I know this works in "C"-locale, but I need it with UTF-8, "C locale" and "UTF8" are entirely orthogonal things. regards, tom lane
- Follow-Ups:
- Re: 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 ?
- References:
- 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: record fields as columns in reports
- Next by Date: Re: record fields as columns in reports
- Previous by thread: Re: Is index usage in LIKE-queries with UTF-8 implemented in PG-8.3 ?
- Next by thread: Re: Is index usage in LIKE-queries with UTF-8 implemented in PG-8.3 ?
- Indexes: