Re: Best way to use indexes for partial match at

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Andrus" <eetasoft(at)online(dot)ee>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Best way to use indexes for partial match at
Date: 2005-11-11 19:43:10
Message-ID: 21086.1131738190@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Andrus" <eetasoft(at)online(dot)ee> writes:
>> (Hint: all the other ones use dictionary
>> sorting rules, which have at least a discrimination against spaces.)

> show lc_collate; -- returns "Estonian_Estonia.1257"
> ...
> I don't see any space discrimination on sorting here.

Hmm ... I should probably have qualified my statement as "all the
locales generally used on Unix systems". I have no idea what the
situation is like on Windoze.

Anyone have some data about the sort rules used by common Windows
locales?

regards, tom lane

In response to

Browse pgsql-general by date

  From Date Subject
Next Message William Yu 2005-11-11 21:21:58 Re: Choosing PostgreSQL as the database for our next project
Previous Message Tom Lane 2005-11-11 18:55:27 Re: Performance of autovacuum and full vacuum of database