I want to concatenate 2 fields :
tpmov char(4) | dsmov char(10)
---------------+----------------
AB | SOMETHING
If I do:
SELECT tpmov || dsmov as History ...
if the field tpmov has a fixed lenght of char(4) the result
expected (I suppose) may be
History
--------------
AB SOMETHING
But Postgres returns
History
------------
ABSOMETHING
Why this occurs ?
How I can get the first result ( AB__SOMETHING ) ?
If I do a select with the literal strings the result is as expected :
SELECT 'AB ' || 'SOMETHING' AS History ;
History
--------------
AB SOMETHING
My reasoning is wrong or this is a bug ?