Re: [ADMIN] Sensitive sort problem?

[Andrei Bintintan]

I give an example:   These are the datas from the table names:   id   n1   n2   1   AaAa    AaAa   2    X     X   3    A     A   4   a    a   5   ab    ab   6   _Y    _Y   8   ..a    ..a   9   .x    .x   7   ...a    ...a   If I run: select * from names order by n1: the result is:   id   n1   n2   4   a    a   8   ..a    ..a   7   ...a    ...a   3    A     A   1   AaAa    AaAa   5   ab    ab   9   .x    .x   2    X     X   6   _Y    _Y     Which I don't think that is right. I don't know what happened. But I find that the ASCII char order is not respected here.   I have another machine on which the result is okay....I don't have a clue.   Andy.   ----- Original Message ----- From: Donald Fraser To: [ADMIN] Sent: Tuesday, November 25, 2003 6:21 PM Subject: Re: [ADMIN] Sensitive sort problem? PostgreSQL 7.3.x and anything below has never had case insensitive sorting - period. I can't speak for the new 7.4 version?   If you want to add a case insensitive data type try this: http://gborg.postgresql.org/project/citext/projdisplay.php     Regards Donald Fraser. ----- Original Message ----- From: Andrei Bintintan To: [EMAIL PROTECTED] Sent: Tuesday, November 25, 2003 3:04 PM Subject: [ADMIN] Sensitive sort problem? Hi to everyone,   I don't know exactly if i'm sending my problem in the right place, hope you can help me.   I use postgresql db. 7.3.2.   Today I noticed that my database does not sort "case sensitive" anymore. If I have a query like: Select name from names order by name  -- the names are not resulted as they should. 'ax' is after 'Aa' and so one.   I don't know since when is this problem I noticed it just now. I use Suse 8.2 and yesterday evening I made a live update. Could this be the problem? I restored the system and ... the problem remains.   I also have another linux system, there the db works fine.   Does anyone has any ideea???? Are there any settings for something like this?   Thnkx. Andy.