From: | "Donald Fraser" <demolish(at)cwgsy(dot)net> |
---|---|
To: | "[ADMIN]" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: Sensitive sort problem? |
Date: | 2003-11-25 16:21:52 |
Message-ID: | 005701c3b370$3d09fe40$1664a8c0@DEMOLITION |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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: pgsql-admin(at)postgresql(dot)org
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-11-25 16:36:17 | Re: Sensitive sort problem? |
Previous Message | Tom Lane | 2003-11-25 16:16:49 | Re: ERROR: pltcl: Cache lookup for attribute |