Re: Bug in parser? - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Bug in parser?
Date
Msg-id 26798.1054481546@sss.pgh.pa.us
Whole thread Raw
In response to Bug in parser?  (Gerhard Dieringer <Gerhard.Dieringer@arcor.de>)
List 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

pgsql-bugs by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: sudoers file??
Next
From: Bruno Wolff III
Date:
Subject: Re: Bug or not...