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 [EMAIL PROTECTED]
EnterpriseDB http://enterprisedb.com 512.569.9461 (cell)
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
