Skip site navigation (1) Skip section navigation (2)

Re: UTF-8 and LIKE vs =

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 (view raw or flat)
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.

In response to

pgsql-general by date

Next:From: Tom LaneDate: 2004-08-26 17:59:17
Subject: Re: Stored procedure failure
Previous:From: Tom LaneDate: 2004-08-26 16:47:24
Subject: Re: R: R: space taken by a row & compressed data

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group