This is part of The Pile, a partial archive of some open source mailing lists and newsgroups.
Subject: Re: [HACKERS] Postgresql 6.5.3-2 for redhat 6.1 From: Lamar Owen <lamar.owen@wgcr.org> Date: Wed, 8 Dec 1999 21:45:19 -0500 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 212 3212 3212 (4 rows) Just like it's supposed to. PostgreSQL 6.5.3-2nl on RedHat 6.1. ===