Order by behaviour

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

Responses

Browse pgsql-general by date

  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?