Frans Van Elsacker <fve@atbib.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