| From: | Lincoln Yeoh <lyeoh(at)pop(dot)jaring(dot)my> |
|---|---|
| To: | David Wheeler <david(at)kineticode(dot)com> |
| Cc: | twanger(at)bluetwanger(dot)de, barwick(at)gmail(dot)com, pgsql-general(at)postgresql(dot)org, Tatsuo Ishii <t-ishii(at)sra(dot)co(dot)jp>, Peter Eisentraut <peter_e(at)gmx(dot)net> |
| Subject: | Re: UTF-8 and LIKE vs = |
| Date: | 2004-08-26 17:01:02 |
| Message-ID: | 5.2.1.1.1.20040827005444.02ed6ba0@localhost |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
At 09:41 AM 8/26/2004 -0700, David Wheeler wrote:
>>What would be useful would be functions to allow selects etc to be
>>ordered as if under different query specifiable locales.
>
>Wouldn't that require different indexes for the different locales? (Where
>there are indexes, of course.)
That's optional I think - depends on amount of data selected and how
selective the indexes would be.
It should be just like any other index on a function- like having an index
on lower(text).
You have index on locale('korean',text) and so on.
Not really sure how to do that tho :). Anyone have ideas?
Should be possible right?
Link.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2004-08-26 17:59:17 | Re: Stored procedure failure |
| Previous Message | Tom Lane | 2004-08-26 16:47:24 | Re: R: R: space taken by a row & compressed data |