Subject: String Concatenation does not work. - Mailing list pgsql-general

>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?

> Regargs,
>        Holger Klawitter

Well in version 6.4 this works:
  SELECT * FROM x WHERE a = b or a=c;

Hope that helps.
J.L.