postgres_rh6x

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.

===


the rest of The Pile (a partial mailing list archive)

doom@kzsu.stanford.edu