Column | Type | Modifiers
--------+---------------+-----------
c | character(20) |
decibel=# select c, c || ('x'::char) from c;
c | ?column?
----------------------+----------
x | xx
I would think that c || 'x' would result in 'x x', but it doesn't because the only text concatenation function we have is textcat(text,
text). As soon as you cast a char to text, you lose all the trailing spaces.
Is this what the spec says should happen?
--
Jim Nasby jim(at)nasby(dot)net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)