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

From Michael Glaesemann
Subject Re: UTF-8 and LIKE vs =
Date
Msg-id 853BC27C-FAE5-11D8-A2A0-000A95C88220@myrealbox.com
Whole thread Raw
In response to Re: UTF-8 and LIKE vs =  (David Wheeler <david@kineticode.com>)
Responses Re: UTF-8 and LIKE vs =
List pgsql-general
On Aug 31, 2004, at 9:16 AM, David Wheeler wrote:

> As far as I know, collation is essentially how an index is ordered,
> correct? So that when I so an "ORDER BY" query, the order in which the
> rows are returned is determined by the collation. Is that correct?

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.

Michael Glaesemann
grzm myrealbox com


pgsql-general by date:

Previous
From: David Wheeler
Date:
Subject: Re: UTF-8 and LIKE vs =
Next
From: David Wheeler
Date:
Subject: Re: UTF-8 and LIKE vs =