I'm trying to update a column to it's orignal contents plus a space plus the
contents of another column.
SET citation = citation + ' ' + text(year);
(citation is text type and year is char type, hence the use of text()
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
pgsql-novice by date
|Next:||From: ERIC Lawson - x52010||Date: 2001-02-28 19:22:19|
|Subject: Re: update questsion|
|Previous:||From: Allen.Kimberly||Date: 2001-02-28 15:45:18|
|Subject: postgres 6.5.2 questions|