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
concatenationfunction 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@nasby.net
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
