Hello
postgres=# create table name(fn text,ln text);
fn and ln could be nulls, so instead of
SELECT COALESCE(fn,'')||' '||COALESCE(ln,'') from name should be used. This is because NULL||TEXT = NULLpostgres=# select fn||' '||ln as name from name;
-- Julius Tuskenis Programavimo skyriaus vadovas UAB nSoft mob. +37068233050 -- Sent via pgsql-admin mailing list ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
