Re: Fixed chars

2018-03-28 Thread Enrico Pirozzi
Resolved...my missing Thanks Enrico https://www.postgresql.org/docs/10/static/datatype-character.html "Values of type|character|are physically padded with spaces to the specified width/|n|/, and are stored and displayed that way. However, trailing spaces are treated as semantically insigni

Re: Fixed chars

2018-03-28 Thread Andreas Kretschmer
Am 28.03.2018 um 11:11 schrieb Enrico Pirozzi: Hi , I've seen this strange thing. sitedb=# create table test_tb(codice char(7)); CREATE TABLE sitedb=# insert into test_tb values('pippo'); INSERT 0 1 sitedb=# select codice || 'a'::char(1),length(codice) from test_tb  ?column? | length -