[GENERAL] array_cat null reasoning

2008-10-30 Thread Kev
Hi, I'm a bit confused as to the logic of nulls. I understand that null is to represent an unknown value. So it makes sense that the result of tacking an unknown value onto a known one is unknown, because you don't know what exactly you just tacked on. So select null::text || 'hello';

Re: [GENERAL] array_cat null reasoning

2008-10-30 Thread Tom Lane
Kev [EMAIL PROTECTED] writes: ... should I be careful how to code because this might change in the future? Probably. We couldn't even handle nulls within arrays until a release or two ago. I wouldn't be surprised if someone comes up with a proposal to make null-array handling a bit more