The following bug has been logged online: Bug reference: 3561 Logged by: Alexander Kirpa Email address: [EMAIL PROTECTED] 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 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
