ordering RH6.1

On Wed, 08 Dec 1999, I wrote:
> I have a table with a field varchar(5), filed with right alligned numbers.
> Ordering was fine, just like we expected compared with nummeric.
>
> Starting from RedHat version 6.1 the ordening seems to remove the leading
> blanco's, what was not for use. I try different versions of postgres, as
> there are 6.5.2-1, 6.5.3-1, 6.5.3-2
> I also try to change varchar in char, and remove the index on the varchar
> field but nothing helps.

Today i take up again and see the ordering for me (third time i install
RH6.1), now
with postgres version 6.5.2-1
the problem is always the same

When i do the following
CREATE TABLE BLANK (column1 varchar(5));
INSERT INTO BLANK (column1) VALUES (' 1');
INSERT INTO BLANK (column1) VALUES (' 11');
INSERT INTO BLANK (column1) VALUES (' 100');
INSERT INTO BLANK (column1) VALUES (' 2');

then:
SELECT * FROM BLANK order by column1;

I received

1
100
11
2 --> mark also a not aligned output.

and I expected
1
2
11
100

Anybody has an idea??

Frans