Gerhard Dieringer <Gerhard(dot)Dieringer(at)arcor(dot)de> writes:
> Inconsistent results when calling '+' operator with text arguemts
I suspect you are looking for the '||' operator, which is the SQL-standard
spelling of concatenation. '+' ends up invoking the one-byte-"char"
datatype's addition operator.
regards, tom lane