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
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? |