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 co

[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'; ..