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: 2007-06-28 15:20:56
Message-ID: 5092.1183044056@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Andrew Sullivan 2007-06-28 15:21:51 Re: record fields as columns in reports
Previous Message Reinoud van Leeuwen 2007-06-28 14:46:15 record fields as columns in reports