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-1the 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
110011 2 --> mark also a not aligned output.
and I expected 1 2 11 100
Anybody has an idea??
Frans