Thread: String Concatenation does not work.

String Concatenation does not work.

From
Holger Klawitter
Date:
Hi there,

I tried to place a query like "SELECT * FROM x WHERE a = b || c" where
a, b and c are text columns in table x.
Unfortunately all I get are Syntax Errors pointing to the concatenation
operator. This happens under 6.3.<latest> with psql and jdbc.

Am I just tripping over a bug or do have to use some kind of escaping?

BTW: Is LIKE case sensitive or not? Should it be?
     I suggest appending "~~*" and "!~~*".

Regargs,
    Holger Klawitter
--
Holger Klawitter
holger.klawitter@gmx.de           http://wwwmath.uni-muenster.de/~holger