Thread: Subject: String Concatenation does not work.

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

> >I tried to place a query like "SELECT * FROM x WHERE a = b || c" where
>
> Well in version 6.4 this works:
>   SELECT * FROM x WHERE a = b or a=c;

Ahem, in PostQuel the || Operator stands for string concatenation not
for the logical or. Anyhow, I found out that under 6.4.2 the following
construct seems to work, however, all brackets are neccessary:
    SELECT * from x WHERE a ~~ (( '%' || b ) || '%' );

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

> > >I tried to place a query like "SELECT * FROM x WHERE a = b || c" where
> >
> > Well in version 6.4 this works:
> >   SELECT * FROM x WHERE a = b or a=c;
>
> Ahem, in PostQuel the || Operator stands for string concatenation not
> for the logical or. Anyhow, I found out that under 6.4.2 the following
> construct seems to work, however, all brackets are neccessary:
>     SELECT * from x WHERE a ~~ (( '%' || b ) || '%' );

|| is the SQL standard way to do it.  I realize it seems confusing.

--
  Bruce Momjian                        |  http://www.op.net/~candle
  maillist@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026