Re: [ADMIN] Sensitive sort problem?

2003-11-26 Thread Andrei Bintintan
there something. If I found something strange I post it. Thankx to all. - Original Message - From: Stephan Szabo [EMAIL PROTECTED] To: Andrei Bintintan [EMAIL PROTECTED] Cc: [ADMIN] [EMAIL PROTECTED] Sent: Tuesday, November 25, 2003 7:53 PM Subject: Re: [ADMIN] Sensitive sort problem

Re: [ADMIN] Sensitive sort problem?

2003-11-26 Thread Andrei Bintintan
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

Re: [ADMIN] Sensitive sort problem?

2003-11-26 Thread Andrei Bintintan
there something. If I found something strange I post it. Thankx to all. - Original Message - From: Stephan Szabo [EMAIL PROTECTED] To: Andrei Bintintan [EMAIL PROTECTED] Cc: [ADMIN] [EMAIL PROTECTED] Sent: Tuesday, November 25, 2003 7:53 PM Subject: Re: [ADMIN] Sensitive sort problem

Re: [ADMIN] Sensitive sort problem?

2003-11-25 Thread Donald Fraser
- 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

Re: [ADMIN] Sensitive sort problem?

2003-11-25 Thread Tom Lane
Donald Fraser [EMAIL PROTECTED] writes: PostgreSQL 7.3.x and anything below has never had case insensitive sorting = - period. This is incorrect. In point of fact it will depend on the locale the database is running under. I think the OP's problem is he re-initdb'd without noting what locale

Re: [ADMIN] Sensitive sort problem?

2003-11-25 Thread Donald Fraser
- Original Message - Donald Fraser [EMAIL PROTECTED] writes: PostgreSQL 7.3.x and anything below has never had case insensitive sorting = - period. This is incorrect. In point of fact it will depend on the locale the database is running under. I think the OP's problem is he

Re: [ADMIN] Sensitive sort problem?

2003-11-25 Thread Stephan Szabo
On Tue, 25 Nov 2003, Andrei Bintintan wrote: I give an example: These are the datas from the table names: id n1 n2 1 AaAaAaAa 2X X 3A A 4 aa 5 abab 6 _Y_Y 8 ..a..a 9 .x.x 7 ...a...a If I run: select * from names order