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.
In response to
pgsql-general by date
|Next:||From: Tatsuo Ishii||Date: 2004-08-31 01:06:21|
|Subject: Re: Hebrew support -- please help !|
|Previous:||From: Michael Glaesemann||Date: 2004-08-31 00:34:29|
|Subject: Re: UTF-8 and LIKE vs =|