Hello
> postgres=# create table name(fn text,ln text);
fn and ln could be nulls, so instead of
> postgres=# select fn||' '||ln as name from name;
SELECT COALESCE(fn,'')||' '||COALESCE(ln,'') from name should be used.
This is because NULL||TEXT = NULL
--
Julius Tuskenis
Programavimo skyriaus vadovas
UAB nSoft
mob. +37068233050