CREATE TABLE foo ("key" int4 NOT NULL, "data1"
varchar(20), "data2" varchar(20));
INSERT INTO foo VALUES ('1','zzz');
SELECT * FROM foo ;
key | data1 | data2
-----+-------+-------
1 | zzz |
(1 row)
SELECT key || '|' || data1 || '|' || data2 FROM foo;
?column?
----------
(1 row)
If data1 or data2 are NULL the request is NULL
__________________________________
Do you Yahoo!?
Yahoo! Calendar - Free online calendar with sync to Outlook(TM).
http://calendar.yahoo.com