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