BUG #3561: CHAR(x) blank stripped. Server or documentation bug?
От | Alexander Kirpa |
---|---|
Тема | BUG #3561: CHAR(x) blank stripped. Server or documentation bug? |
Дата | |
Msg-id | 200708210857.l7L8v5CZ091446@wwwmaster.postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #3561: CHAR(x) blank stripped. Server or documentation bug?
|
Список | 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 по дате отправления: