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

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

pgsql-general by date

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

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