Subject: String Concatenation does not work.

From: leshan(at)ugsolutions(dot)com
To: pgsql-general(at)postgresql(dot)org
Subject: Subject: String Concatenation does not work.
Date: 1999-01-06 16:52:28
Message-ID: 369394CB.CC9B0515@ugsolutions.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mark Joseph Holmes 1999-01-06 17:44:14 PostgreSQL 6.4.1 backup procedure on live web server
Previous Message Bruce Momjian 1999-01-06 16:21:41 Re: [GENERAL] Patch 6.4.1 to 6.4.2