Thread: bug in the concatenation of the selection...

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

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