I'm trying to update a column to it's orignal contents plus a space plus the
contents of another column.
UPDATE cases
SET citation = citation + ' ' + text(year);
(citation is text type and year is char type, hence the use of text()
function)
I get: Unable to identify an operator '+' for types 'text' and 'unknown'
I can't find any documentation on how to this sort of thing, so any help is
appreciated. -Don