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 17:52:42
Message-ID: 20233.1131731562@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Andrus" <eetasoft(at)online(dot)ee> writes:
> Maybe there is some setting which I can use to inform Postgres that sorting
> order is strictly by single byte, not affected by byte sequences.

AFAIK, C/POSIX is the *only* commonly used locale in which that holds.
Do you have a counterexample? (Hint: all the other ones use dictionary
sorting rules, which have at least a discrimination against spaces.)

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Carlos Oliva 2005-11-11 18:09:45 Re: Performance of autovacuum and full vacuum of database
Previous Message Bruno Wolff III 2005-11-11 17:44:45 Re: A good postgresql book