BUG #3561: CHAR(x) blank stripped. Server or documentation bug?

From: "Alexander Kirpa" <postgres(at)bilteks(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #3561: CHAR(x) blank stripped. Server or documentation bug?
Date: 2007-08-21 08:57:05
Message-ID: 200708210857.l7L8v5CZ091446@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 3561
Logged by: Alexander Kirpa
Email address: postgres(at)bilteks(dot)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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Gregory Stark 2007-08-21 11:04:51 Re: BUG #3561: CHAR(x) blank stripped. Server or documentation bug?
Previous Message Heikki Linnakangas 2007-08-20 19:15:37 Re: BUG #3558: Comunication cut after 5 mins aprox. in remote acces to Postgres