String Concatenation does not work.

From: Holger Klawitter <holger(dot)klawitter(at)gmx(dot)de>
To: pgsql-general(at)postgresql(dot)org
Subject: String Concatenation does not work.
Date: 1999-01-05 10:17:08
Message-ID: 3691E6A4.1F9673E9@gmx.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(dot)klawitter(at)gmx(dot)de http://wwwmath.uni-muenster.de/~holger

Browse pgsql-general by date

  From Date Subject
Next Message Scherf Andreas 1999-01-05 10:34:06 Creating Tables
Previous Message Anatoly K. Lasareff 1999-01-05 09:15:43 Re: [GENERAL] Triggers and sql functions not working...