Gerhard Dieringer <Gerhard.Dieringer@arcor.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