Re: [BUGS] furiously yours

2001-06-09 Thread Stephan Szabo
That's mostly because your c program is wrong. If you reorder the strings you'll see that it's not sorting at all. It's just giving them back in the order you gave them. You should not compare the output from strcmp to -1. It's <0, 0, >0 not -1, 0, 1. When I run the below program and add a p

Re: [BUGS] furiously yours

2001-06-09 Thread Tom Lane
"Rony Khoury" <[EMAIL PROTECTED]> writes: > Lamer I checked the parameters on my system and did not find LC_ALL nor > LC_COLL, but I found LANG=en_US. Indeed, you are getting en_US collation order. Try setting LANG=C and then redoing initdb. Or, if you really have no use for non-C locale, you

Re: [BUGS] furiously yours

2001-06-09 Thread Rony Khoury
Hello again, If I understood right Postgresql depends on C language to do the sorting, and C language depends on the settings of redhat for the sorting task. Before going to RedHat with that I took the liberty to do the following test and I would like to take your opinion about it first. I i