Re: [GENERAL] Subject: String Concatenation DOES work.

> > >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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026