Wrong sort-order

From: "Tarabas" <tarabas(at)tarabas(dot)de>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Wrong sort-order
Date: 2002-04-16 16:25:11
Message-ID: IEEEIIEOMKMOKHPPJGJIAEMHDOAA.tarabas@tarabas.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi!

Iam again having trouble with my postgresql ... when I do a
"select * from mytable order by username" then I get a result that's kinda
in the wrong order ...

It seems to make 2 different sorted blocks ... one starts with records that
start with "0...." sorted fom 0-Z and the other one comes directly after the
first one and starts with "_" again sorted from "_" - Z ... that is very odd
...

Does anyone have any idea what happened here ?! Any index or something i
have to recreate for the table ?!? I have 10293 in the table the column i
try to order by is varchar(255) and I use postgres 7.2.1 on RedHat Linux ...
i just "patched" the maximum arguments for functions to 64 instead of 16 ...

Greetings ... Manuel ...

Browse pgsql-general by date

  From Date Subject
Next Message Tarabas 2002-04-16 16:33:11 Re: Wrong sort-order
Previous Message Hans-Juergen Schoenig 2002-04-16 16:13:52 Re: Triggers and System Tables