BUG #1183: order by ignoring whitespaces on collate pt_BR

From: "PostgreSQL Bugs List" <pgsql-bugs(at)postgresql(dot)org>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #1183: order by ignoring whitespaces on collate pt_BR
Date: 2004-06-25 13:40:36
Message-ID: 20040625134036.94A2ECF4D23@www.postgresql.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2004-06-25 14:04:31 Re: BUG #1183: order by ignoring whitespaces on collate pt_BR
Previous Message Richard Huxton 2004-06-25 10:39:33 Re: Problem with now() on 7.4.1-3 under cygwin?