ordering RH6.1
От | Frans Van Elsacker |
---|---|
Тема | ordering RH6.1 |
Дата | |
Msg-id | 3.0.6.32.19991214234647.00885100@193.75.233.1 обсуждение исходный текст |
Ответы |
Re: [HACKERS] ordering RH6.1
|
Список | pgsql-hackers |
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
В списке pgsql-hackers по дате отправления: