>
> Hi,
>
> I try concatenate text via standard '||' oprerator, but result is
> interesting:
>
> PgSQL 6.5.3/7.0:
> ~~~~~~~~~~~~~~~
> test=> select * from x;
> a |b
> ---+---
> AAA|BBB
> xxx|
> (2 rows)
>
> test=> select a || b from x;
> ?column?
> --------
> AAABBB
> <-------------- empty !
> (2 rows)
NULL's can not be concatenated, but '' can. Looks fine to me:
---------------------------------------------------------------------------
test=> create table ff (x text, y text);insCREATEtest=> insert into ff values ('a','');INSERT 19082 1test=> insert into
ffvalues ('b',null);INSERT 19083 1test=> select x || y from ff; ?column? ---------- a (2 rows)
-- 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,
Pennsylvania19026