Re: [HACKERS] ordering RH6.1

I download all the rpm from
(http://www.ramifordistat.net/postgres/RPMS/redhat-6.x/postgresql*-2nl.i386.
rpm)
and have install each of them in redhat 6.1.

But we received the same bad results as before.
- my redhat was downloaded from a mirror site as a cd-image- and there where some older version of postgres (v 6.5.2-1)
installedon
 
our test system before. They were first uninstalled.

This are the only two packages that we have running on our machine. I've
choose the half-automatic graphic install of redhat. Selected some standard
tools like ftp, network tool,... and choose a belgian keyboard. I have left
the timezone selection as default.

Strange things!

I see only the following posibilities :    - Our redhat cd-image is different from yours (Why ??)    - influence of the
olderversions     - keyboard settings ???
 

This is our result :

[postgres@dekatest pgsql]$ psql test
Welcome to the POSTGRESQL interactive sql monitor: Please read the file COPYRIGHT for copyright terms of POSTGRESQL
[PostgreSQL 6.5.3 on i586-pc-linux-gnu, compiled by gcc egcs-2.91.66]
  type \? for help on slash commands  type \q to quit  type \g or terminate with semicolon to execute queryYou are
currentlyconnected to the database: test
 

test=> CREATE TABLE BLANK (column1 varchar(5));
CREATE
test=> INSERT  INTO BLANK (column1) VALUES ('    1');
INSERT 587145 1
test=> INSERT  INTO BLANK (column1) VALUES ('   11');
INSERT 587146 1
test=> INSERT  INTO BLANK (column1) VALUES ('  100');
INSERT 587147 1
test=> INSERT  INTO BLANK (column1) VALUES ('    2');
INSERT 587148 1
test=> SELECT * FROM BLANK order by column1;
column1
-------     1   100    11     2
(4 rows)         
Any Idea ?

greetings,
Frans


At 10:55 15/12/99 -0500, you wrote:
>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.
>
>--
>Lamar Owen
>WGCR Internet Radio
>1 Peter 4:11
>
>