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 Ed Loehr <ELOEHR@austin.rr.com>
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 по дате отправления
От: wieck@debis.com (Jan Wieck)
Дата:
От: Peter Eisentraut
Дата:
FAQ