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