BUG #1183: order by ignoring whitespaces on collate pt_BR
| От | PostgreSQL Bugs List |
|---|---|
| Тема | BUG #1183: order by ignoring whitespaces on collate pt_BR |
| Дата | |
| Msg-id | 20040625134036.94A2ECF4D23@www.postgresql.com обсуждение |
| Ответы |
Re: BUG #1183: order by ignoring whitespaces on collate pt_BR
|
| Список | pgsql-bugs |
The following bug has been logged online:
Bug reference: 1183
Logged by: Everton Luis Berz
Email address: everton@faccat.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
В списке pgsql-bugs по дате отправления: