The following bug has been logged online:

Bug reference: 1183
Logged by: Everton Luis Berz

Email address: everton (AT) faccat (DOT) br

PostgreSQL version: 7.4

Operating system: Linux Slackware 9.1

Description: order by ignoring whitespaces on collate pt_BR

Details:

The order by is ignoring whitespaces.
Follow example:

# select codigo, nome from usa_nalu where nome ilike 'maria%' ORDER BY
NOME;
(...)
codigo | nome
----------+-------------------------------
003414 | MARIA NILDA DA SILVA E SILVA
1040534 | MARIA NILZA GOMES GRASSMANN
503/0028 | MARIAN MINEGAS
10305081 | MARIANO ANDRE ANDERSON
871104 | MARIANO DE CASTILHOS PETERSEN
001726 | MARIA NOELI ZIMMER CLEMENT
931129 | MARIA ODETE DA SILVA APOLLO
002351 | MARIA ONEIDE DO AMARAL
(...)

MARIA-MARIAN-MARIANO-MARIA again?

My configuration is:
# select name, setting from pg_settings where name in
('client_encoding', 'server_encoding', 'lc_collate');
name | setting
-----------------+---------
client_encoding | LATIN1
lc_collate | pt_BR
server_encoding | LATIN1





---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

"PostgreSQL Bugs List" <pgsql-bugs (AT) postgresql (DOT) org> writes:
Most non-C locales are designed to do that. This isn't a bug.

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly