Andres Cuevas wrote:
If data1 or data2 are NULL the request is NULL
Which is the correct behavior, not a bug. See:
http://techdocs.postgresql.org/guides/BriefGuideToNulls
HTH,
Joe
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ
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
