Combining text fields

Поиск
Список
Период
Сортировка
Искать
От
Doug Silver
Тема
Combining text fields
Дата
Msg-id
200310171646.19085.dsilver@urchin.com
Список
Дерево обсуждения
Combining text fields Doug Silver <dsilver@urchin.com>
Re: Combining text fields Josh Berkus <josh@agliodbs.com>
Re: Combining text fields Nabil Sayegh <postgresql@e-trolley.de>
I just want to confirm that this is the correct behavior for the return value 
when combining text fields together.  If one of the fields is NULL, then the 
return value of field1+field2 also becomes NULL.  If this is correct, is the 
proper way to get around this to use a default value of '' for such fields?

TIA

-doug

# create table test2 (street1 varchar(10),street2 varchar(10),id serial);
NOTICE:  CREATE TABLE will create implicit sequence 'test2_id_seq' for SERIAL 
column 'test2.id'
CREATE TABLE
test=# insert into test2 (street1) values('123 main');
INSERT 832047 1
test=# select street1||' '||street2||'|' as street1,'|'||street2||'|' from 
test2;
 street1 | ?column?
---------+----------
         |
(1 row)

test=# select street1||' '||street2||'|' as 
street1,'|'||street1||'|,'|'||street2||'|' from test2;
test'#
test=# select street1||' '||street2||'|' as 
street1,'|'||street1||'|','|'||street2||'|' from test2;
 street1 |  ?column?  | ?column?
---------+------------+----------
         | |123 main| |


В списке pgsql-novice по дате отправления
От: devicenull@linuxmail.org (dev o'null)
Дата:
От: Josh Berkus
Дата:
Сообщение: Re: Combining text fields
FAQ