Postgres Pro
Downloads
Home   >   mailing lists

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

From Holger Klawitter
Subject String Concatenation does not work.
Date
Msg-id 3691E6A4.1F9673E9@gmx.de
Whole thread Raw
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: tolik@icomm.ru (Anatoly K. Lasareff)
Date:
Subject: Re: [GENERAL] Triggers and sql functions not working...
Next
From: Scherf Andreas
Date:
Subject: Creating Tables