Hello again,
I've been playing around with different versions of
postgresql, I noticed that if I install the rpms of postgresql7.1 the sorting
order become the way I want it. other versions including 7.1.1 and 7.1.2 are
similar to version 7.0.3 where the sorting is different then 7.1.
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
"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
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
I've been using postgresql for a quite some time and I have nothing to say
about it except it is wonderfull.
I recently upgraded to linux redhat 7.1 that had postgresql 7.0.3 on it and
started using it.
I know I should upgrade to the latest version but since I was behind on time
and I'm not
