Skip site navigation (1) Skip section navigation (2)

Re: furiously yours

From: Lamar Owen <lamar(dot)owen(at)wgcr(dot)org>
To: "Rony Khoury" <rkrk(at)hotmail(dot)com>, pgsql-bugs(at)postgresql(dot)org
Cc: teg(at)redhat(dot)com
Subject: Re: furiously yours
Date: 2001-06-08 15:53:00
Message-ID: 01060811530000.00919@lowen.wgcr.org (view raw or flat)
Thread:
Lists: pgsql-bugs
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

On Friday 08 June 2001 05:20, Rony Khoury wrote:
[collation sequencing problem regarding space interpretation in ORDER BY]
> I would like to know if this was solved in the new version? and if not
> someone should defenetly do something about it.

This is not a PostgreSQL issue, but a locale issue that was introduced by Red 
Hat implementing 'correct' locale collation. PostgreSQL has to rely on the 
system's C library for the string comparison/collation routines -- and those 
routines are greatly changed by the locale setting.

Red Hat does not view this behavior as buggy.

Trond, I didn't know whether you are subscribed to the BUGS list or not, so I 
am  CC'ing you on this.  The two collations:

example
new version:
BOU MOUSLEH
BOUSTANI
BOU YAZBEK

old version
BOU MOUSLEH
BOU YAZBECK
BOUSTANI

This appears to me to be wrong, Trond.  Red Hat 7.1 out of the box 
installation.

Rony, in the normal usage of these names, what would the correct collation be?
- --
Lamar Owen
WGCR Internet Radio
1 Peter 4:11

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.4 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iD8DBQE7IPTi5kGGI8vV9eERAnesAKC0RxdvdPs3EcFR9MAkapPs5drwbQCfVQuY
xrUfcfOFjEzLdCPsLbV59PM=
=bsSL
-----END PGP SIGNATURE-----

In response to

pgsql-bugs by date

Next:From: Peter EisentrautDate: 2001-06-08 16:26:21
Subject: Re: furiously yours
Previous:From: Robert E. BruccoleriDate: 2001-06-08 13:32:38
Subject: Re: Apparent deadlock for simultaneous sequential scans

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group