Re: [HACKERS] Postgresql 6.5.3-2 for redhat 6.1

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.

--
Lamar Owen
WGCR Internet Radio
1 Peter 4:11