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