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