From: | "Carlos H(dot) Reimer" <carlos(dot)reimer(at)opendb(dot)com(dot)br> |
---|---|
To: | <pgsql-general(at)postgresql(dot)org> |
Subject: | Order by behaviour |
Date: | 2007-03-28 21:52:04 |
Message-ID: | PEEPKDFEHHEMKBBFPOOKOEMGEEAA.carlos.reimer@opendb.com.br |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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;
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
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
From | Date | Subject | |
---|---|---|---|
Next Message | Raymond O'Donnell | 2007-03-28 22:04:40 | Re: Order by behaviour |
Previous Message | Joseph S | 2007-03-28 19:53:51 | Re: How to speedup CHECKPOINTs? |