Horton

Re: Bug in parser?

Tom Lane <tgl@sss.pgh.pa.us>

View thread
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Gerhard Dieringer <Gerhard.Dieringer@arcor.de>
Cc: Postgres Bugs <pgsql-bugs@postgresql.org>
Date: 2003-06-01T15:32:26Z
Lists: pgsql-bugs 
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