Hello,

I've a problem and i am looking for help?

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.

Going back to redhat 6.0 (and try with the same postgres versions) ordering
becomes fine again.


Any idea??
Frans



Wed, 08 Dec 1999 23:46:58 +0100
Frans Van Elsacker <fve@atbib.be>
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

Wed, 8 Dec 1999 21:45:19 -0500
Lamar Owen <lamar.owen@wgcr.org>
Re: [HACKERS] Postgresql 6.5.3-2 for redhat 6.1