Issue on Varchar Ordering
От | Rodrigo Hjort |
---|---|
Тема | Issue on Varchar Ordering |
Дата | |
Msg-id | 731083980603290704j63aa8d38s4dda54ce97d2e495@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: Issue on Varchar Ordering
|
Список | pgsql-hackers |
Pg-Hackers,<br /><br />I'm having the following issue:<br /><br />create table aluno (id serial, nome varchar(60));<br /><br/>rodrigo=# select * from aluno order by nome offset 35 limit 5;<br /> id | nome<br />----+-----------------------------------<br /> 36 | GABRIELA HELEDA DE SOUZA<br /> 37 | GABRIELA JACOBY NOS<br /> 38 |GABRIEL ALCIDES KLIM PERONDI<br /> 39 | GABRIELA LETICIA BATISTA NUNES<br /> 40 | GABRIEL ALEXANDRE DA SILVA MANICA<br />(5registros)<br /><br />The problem is that records with id 38 and 40 might come before the others. It seems that the spacingisn't considered on ordering. <br />The encoding (LATIN1) is correct according to Brazilian Portuguese, and the settingsare listed below.<br /><br />rodrigo=# select name, setting from pg_settings where name ~ 'encoding|^lc_|version';<br/> name | setting <br />-----------------+---------<br /> client_encoding | LATIN1<br/> lc_collate | pt_BR<br /> lc_ctype | pt_BR<br /> lc_messages | pt_BR<br /> lc_monetary | pt_BR<br/> lc_numeric | pt_BR<br /> lc_time | pt_BR <br /> server_encoding | LATIN1<br /> server_version |8.1.3<br />(9 registros)<br clear="all" /><br />The server is a Debian 3.1 GNU/Linux with locales pt_BR.<br /><br />Whatcould be wrong? Thanks in advance.<br /><br />-- <br />Regards,<br /><br />Rodrigo Hjort<br />GTI - Projeto PostgreSQL<br/>CELEPAR - Cia de Informática do Paraná<br /><a href="http://www.pr.gov.br">http://www.pr.gov.br</a><br /><br/>
В списке pgsql-hackers по дате отправления: