Re: [HACKERS] ordering RH6.1

Frans Van Elsacker <fve(at)atbib(dot)be> writes:
> 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??

Bizarre. I see the expected results under both 6.5.3 and current
development sources:

play=> SELECT * FROM BLANK order by column1;
column1
-------
1
2
11
100
(4 rows)

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...)

regards, tom lane