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 5092.1183044056@sss.pgh.pa.us
Whole thread Raw
In response to 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 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

pgsql-sql by date:

Previous
From: Reinoud van Leeuwen
Date:
Subject: record fields as columns in reports
Next
From: Andrew Sullivan
Date:
Subject: Re: record fields as columns in reports