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 по дате отправления: