Skip site navigation (1) Skip section navigation (2)

Issue on Varchar Ordering

From: "Rodrigo Hjort" <rodrigo(dot)hjort(at)gmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Issue on Varchar Ordering
Date: 2006-03-29 15:04:36
Message-ID: 731083980603290704j63aa8d38s4dda54ce97d2e495@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-hackers
Pg-Hackers,

I'm having the following issue:

create table aluno (id serial, nome varchar(60));

rodrigo=# select * from aluno order by nome offset 35 limit 5;
 id |               nome
----+-----------------------------------
 36 | GABRIELA HELEDA DE SOUZA
 37 | GABRIELA JACOBY NOS
 38 | GABRIEL ALCIDES KLIM PERONDI
 39 | GABRIELA LETICIA BATISTA NUNES
 40 | GABRIEL ALEXANDRE DA SILVA MANICA
(5 registros)

The problem is that records with id 38 and 40 might come before the others.
It seems that the spacing isn't considered on ordering.
The encoding (LATIN1) is correct according to Brazilian Portuguese, and the
settings are listed below.

rodrigo=# select name, setting from pg_settings where name ~
'encoding|^lc_|version';
      name       | setting
-----------------+---------
 client_encoding | LATIN1
 lc_collate      | pt_BR
 lc_ctype        | pt_BR
 lc_messages     | pt_BR
 lc_monetary     | pt_BR
 lc_numeric      | pt_BR
 lc_time         | pt_BR
 server_encoding | LATIN1
 server_version  | 8.1.3
(9 registros)

The server is a Debian 3.1 GNU/Linux with locales pt_BR.

What could be wrong? Thanks in advance.

--
Regards,

Rodrigo Hjort
GTI - Projeto PostgreSQL
CELEPAR - Cia de Informática do Paraná
http://www.pr.gov.br

Responses

pgsql-hackers by date

Next:From: Ludek FinstrleDate: 2006-03-29 15:47:54
Subject: Re: [ODBC] Unable to Query the datatype varchar of PostgreSQL Server
Previous:From: Ludek FinstrleDate: 2006-03-29 14:38:31
Subject: Re: [ODBC] Unable to Query the datatype varchar of PostgreSQL Server

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group