Order by behaviour
| От | Carlos H. Reimer |
|---|---|
| Тема | Order by behaviour |
| Дата | |
| Msg-id | PEEPKDFEHHEMKBBFPOOKOEMGEEAA.carlos.reimer@opendb.com.br обсуждение исходный текст |
| Ответы |
Re: Order by behaviour
Re: Order by behaviour Re: Order by behaviour |
| Список | pgsql-general |
Hi,
We have a PostgreSQL 8.0.6 cluster configured with lc_collate=pt_BR.UTF-8 and when we run the following SELECT:
SELECT substr(nomerazao,1,4),
ascii(substr(nomerazao,1,1)),
ascii(substr(nomerazao,2,1))
from spunico.unico order by nomerazao;
SELECT substr(nomerazao,1,4),
ascii(substr(nomerazao,1,1)),
ascii(substr(nomerazao,2,1))
from spunico.unico order by nomerazao;
is returning:
substr | ascii | ascii
--------+-------+-------
| 32 | 0
| 32 | 0
1000 | 49 | 48
1.DI | 49 | 46
1° R | 49 | 176
2M C | 50 | 77
3A.G | 51 | 65
A. A | 65 | 46
AABA | 65 | 65
A.A. | 65 | 46
A.AG | 65 | 46
A.A. | 65 | 46
A.A. | 65 | 46
ABAS | 65 | 66
ABAS | 65 | 66
ABAT | 65 | 66
A.B. | 65 | 46
A.B. | 65 | 46
ABCC | 65 | 66
A.B. | 65 | 46
A.B. | 65 | 46
--------+-------+-------
| 32 | 0
| 32 | 0
1000 | 49 | 48
1.DI | 49 | 46
1° R | 49 | 176
2M C | 50 | 77
3A.G | 51 | 65
A. A | 65 | 46
AABA | 65 | 65
A.A. | 65 | 46
A.AG | 65 | 46
A.A. | 65 | 46
A.A. | 65 | 46
ABAS | 65 | 66
ABAS | 65 | 66
ABAT | 65 | 66
A.B. | 65 | 46
A.B. | 65 | 46
ABCC | 65 | 66
A.B. | 65 | 46
A.B. | 65 | 46
Are not the lines out of order or is it a normal behaviour for a server with lc_collate=pt_BR.UTF-8?
Thank you in advance!
Reimer
В списке pgsql-general по дате отправления: