Hi
I think it behaves as expected. Look at my select "select encode(charcol::bytea, 'hex') , intcol from z;" it returns 20 which is a space in hex
~/postgres/17/dev/data/ [master*] psql
psql (17devel)
Type "help" for help.
postgres PSQL> create table z (charcol char(1) default ' ', intcol int);
CREATE TABLE
postgres PSQL> insert into z values (' ', 1);
INSERT 0 1
postgres PSQL> insert into z (intcol) values (2);
INSERT 0 1
postgres PSQL> select encode(charcol::bytea, 'hex') , intcol from z;
encode | intcol
--------+--------
20 | 1
20 | 2
(2 rows)
postgres PSQL> select '[' || charcol || ']', intcol from z;
?column? | intcol
----------+--------
[] | 1
[] | 2
(2 rows)
Med venlig hilsen
Peter Gram
Sæbyholmsvej 18
2500 Valby
Mobile: (+45) 5374 7107
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