Eduardo Soares wrote:
> Operating system: Linux Fedora 4
> Description: index error with space character
> Details:
>
> In above example the "AZTES Z" should be after the "AZTESA". It happens with
> any encoding type. The DB not see the space character. The index shoulb see
> the space and put "AZTES Z" together with "AZTES". In above list the
> "AZTESA" should be the first.

Sorting order is determined by your locale, and is different from your
encoding. For example, en_GB ignores spaces but C doesn't:

$ LC_COLLATE=en_GB.UTF-8 sort unsorted.txt
aa a
aaaa
aaab
aa b

$ LC_COLLATE=C sort unsorted.txt
aa a
aa b
aaaa
aaab

See "man locale" for details on how to find out what locales are setup
on your machine. See the documentation for details on how to set locale
on a database cluster.

HTH
--
Richard Huxton
Archonet Ltd

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faq