Re: UTF-8 and LIKE vs =

From: Michael Glaesemann <grzm(at)myrealbox(dot)com>
To: David Wheeler <david(at)kineticode(dot)com>
Cc: pgsql-general(at)postgresql(dot)org, Joel <rees(at)ddcom(dot)co(dot)jp>
Subject: Re: UTF-8 and LIKE vs =
Date: 2004-08-31 00:34:29
Message-ID: 853BC27C-FAE5-11D8-A2A0-000A95C88220@myrealbox.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David Wheeler 2004-08-31 00:39:57 Re: UTF-8 and LIKE vs =
Previous Message David Wheeler 2004-08-31 00:16:20 Re: UTF-8 and LIKE vs =