BUG #3561: CHAR(x) blank stripped. Server or documentation bug? - Mailing list pgsql-bugs

From Alexander Kirpa
Subject BUG #3561: CHAR(x) blank stripped. Server or documentation bug?
Date
Msg-id 200708210857.l7L8v5CZ091446@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #3561: CHAR(x) blank stripped. Server or documentation bug?
List pgsql-bugs
The following bug has been logged online:

Bug reference:      3561
Logged by:          Alexander Kirpa
Email address:      postgres@bilteks.com
PostgreSQL version: 8.2.4
Operating system:   FreeBSD 6.2
Description:        CHAR(x) blank stripped. Server or documentation bug?
Details:

Regarding
http://www.postgresql.org/docs/8.2/interactive/datatype-character.html
char(n) - fixed-length, blank padded
In live:
CREATE TABLE test1 (a character(6),b varchar(6));
INSERT INTO test1 VALUES ('ok','ok');
INSERT INTO test1 VALUES (' bad ',' bad ');
INSERT INTO test1 VALUES ('  poor','  poor');
select '['||a||']' as aa,'['||b||']' as bb from test1;
INSERT INTO test1 VALUES ('ok','ok');
INSERT INTO test1 VALUES (' bad ',' bad ');
INSERT INTO test1 VALUES ('  poor','  poor');
select '['||a||']' as aa,'['||b||']' as bb from test1;
    aa    |    bb
----------+----------
 [ok]     | [ok]
 [ bad]   | [ bad ]
 [  poor] | [  poor]
(3 rows)
It is easy to see that char(x) field really blank stripped.
This is bug of server or documentation?

Best regards,
 Alexander Kirpa

pgsql-bugs by date:

Previous
From: Heikki Linnakangas
Date:
Subject: Re: BUG #3558: Comunication cut after 5 mins aprox. in remote acces to Postgres
Next
From: Gregory Stark
Date:
Subject: Re: BUG #3561: CHAR(x) blank stripped. Server or documentation bug?