[GENERAL] Subject: String Concatenation DOES work.

[Holger Klawitter]

> >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
[EMAIL PROTECTED]           http://wwwmath.uni-muenster.de/~holger