Re: [BUGS] BUG #1082: Order by doesn't sort correctly.

2004-02-24 Thread Andreas Pflug
Tom Lane wrote: Richard Neill <[EMAIL PROTECTED]> writes: This ordering is perverse! No kidding. No matter what the priority is of the different characters, I cannot understand how the above can arise. You are assuming that it's a byte-at-a-time process. It's not. I believe the

Re: [BUGS] BUG #1082: Order by doesn't sort correctly.

2004-02-24 Thread Devrim GUNDUZ
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi, On Tue, 24 Feb 2004, Andreas Pflug wrote: > I verified this, and it's not GB specific as one might suggest... Same > with en_US, de_DE, fr_FR, af_ZA. Does this behaviour really make sense > to anybody? Ummm, same with tr_TR (for a long time)

Re: [BUGS] BUG #1082: Order by doesn't sort correctly.

2004-02-24 Thread Tom Lane
Andreas Pflug <[EMAIL PROTECTED]> writes: > I verified this, and it's not GB specific as one might suggest... Same > with en_US, de_DE, fr_FR, af_ZA. Yeah, most of the locales use dictionary ordering rules. > Does this behaviour really make sense to anybody? You'd have to argue about it with th

[BUGS] BUG #1084: dropping in-use index causes "could not open relation with OID..."

2004-02-24 Thread PostgreSQL Bugs List
The following bug has been logged online: Bug reference: 1084 Logged by: Reece Hart Email address: [EMAIL PROTECTED] PostgreSQL version: 7.4 Operating system: linux 2.4.18 (smp) Description:dropping in-use index causes "could not open relation with OID..." Deta