Re: UTF-8 and LIKE vs = - Mailing list pgsql-general

From David Wheeler
Subject Re: UTF-8 and LIKE vs =
Date
Msg-id 4875304A-FAE6-11D8-A2D5-000393D9369E@kineticode.com
Whole thread Raw
In response to Re: UTF-8 and LIKE vs =  (Michael Glaesemann <grzm@myrealbox.com>)
List pgsql-general
On Aug 30, 2004, at 5:34 PM, Michael Glaesemann wrote:

> Just a wee thing, and perhaps not the point of the post, but collation
> is not important only for indexes. (Actually, I wouldn't be surprised
> if some indexes are not necessarily ordered, but that may be my
> inexperience talking.) You don't need an index on column foo to be
> able to ORDER BY foo.

Yes, I know that. I guess I should've left mention of indexes out of
it. I was still thinking in terms of my original issue, where a query
for a particular string found no results when it should have because
the index was using the en_us.utf8 locale.

Regards,

David


pgsql-general by date:

Previous
From: Michael Glaesemann
Date:
Subject: Re: UTF-8 and LIKE vs =
Next
From: Tatsuo Ishii
Date:
Subject: Re: Hebrew support -- please help !