This is part of The Pile, a partial archive of some open source mailing lists and newsgroups.
Subject: Re: [HACKERS] ordering RH6.1 From: Lamar Owen <lamar.owen@wgcr.org> Date: Wed, 15 Dec 1999 10:55:28 -0500 Tom Lane wrote: > I wonder if this could be a LOCALE or MULTIBYTE issue. Do you have > either feature enabled in your copy, and if so what locale/encoding > do you use? (I'm running plain vanilla no-USE_LOCALE, no-MULTIBYTE > code, so that might be why I don't see anything funny...) He's running the RPM distribution, which at that release has --enable-locale but no multibyte. Using the no-locale RPM's I last built, I can't reproduce his results. Frans, try out the no-locale rpm set and see if the result changes, if you please. (using wget, you would do: wget http://www.ramifordistat.net/postgres/RPMS/redhat-6.x/postgresql*-2nl.i386.rpm ) This will verify whether it is locale-related or not. I would install the locale RPMs and test for you right now, but my 6.1 machine is at home. If it is inconvenient for you to download this, let me know, and I'll try to test tonight at home -- although, I've been meaning to do just that for nearly a week now, but I haven't even fired up the machine at home in the last week. === Subject: Re: [HACKERS] ordering RH6.1 From: "Oliver Elphick" <olly@lfix.co.uk> Date: Wed, 15 Dec 1999 10:29:09 +0000 Tom Lane wrote: >Bizarre. I see the expected results under both 6.5.3 and current >development sources: > >play=> SELECT * FROM BLANK order by column1; >column1 >------- > 1 > 2 > 11 > 100 >(4 rows) > >I wonder if this could be a LOCALE or MULTIBYTE issue. Do you have >either feature enabled in your copy, and if so what locale/encoding >do you use? (I'm running plain vanilla no-USE_LOCALE, no-MULTIBYTE >code, so that might be why I don't see anything funny...) I've tried this with both locale and multibyte enabled and with ===