On Wed, 08 Dec 1999, Frans Van Elsacker 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.
As I e-mailed to you before, I cannot reproduce this behaviour on my
installation of RedHat 6.1. If you can provide a session transcript for the
create, some inserts, and a select, then I might be able to help. What is your
locale set to, out of curiousity?
If I do the following:
CREATE TABLE BLANK (column1 varchar(5));
INSERT INTO BLANK (column1) VALUES (' 12');
INSERT INTO BLANK (column1) VALUES (' 212');
INSERT INTO BLANK (column1) VALUES (' 3212');
INSERT INTO BLANK (column1) VALUES ('3212 ');
then:
SELECT * FROM BLANK;
produces:
column1
------- 12 2123212
3212
(4 rows)
Just like it's supposed to.
PostgreSQL 6.5.3-2nl on RedHat 6.1.
--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11