Combining text fields

From: Doug Silver <dsilver(at)urchin(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Combining text fields
Date: 2003-10-17 23:46:41
Message-ID: 200310171646.19085.dsilver@urchin.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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| |

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Josh Berkus 2003-10-18 00:04:48 Re: Combining text fields
Previous Message Dave 2003-10-17 13:53:28 Trouble creating a survey database