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) installed on
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 older versions
- keyboard settings ???

This is our result :

[postgres(at)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 query
You are currently connected 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
>
>