char column with a single space as the default not working

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



All;


I created a table like this:

create table z (charcol char(1) default  ' ', intcol int);


Then I inserted a row with a single space in the charcol column and another insert letting the table use the default value:

insert into z values (' ', 1);

insert into z (intcol) values (2);


However neither of the inserted rows actually retained the single space in the charcol column:


select '[' || charcol || ']', intcol from z;
 ?column? | intcol
----------+--------
 []       |      1
 []       |      2
(2 rows)


Thoughts? Is it possible to add a single space to a char column without it getting truncated?


Thanks in advance






[Index of Archives]     [Postgresql Home]     [Postgresql General]     [Postgresql Performance]     [Postgresql PHP]     [Postgresql Jobs]     [PHP Users]     [PHP Databases]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Yosemite Forum]

  Powered by Linux