Richard Huxton <dev@archonet.com> writes:
> Tom Lane wrote:
>> "Sabin Coanda" <sabin.coanda@deuromedia.ro> writes:
>>> I used the function array_to_string, and I found it ignores NULL values,
>>> e.g. array_to_string( 'ARRAY[1,NULL,3]', ',' ) returns '1,3'.
>>
>> Do you have a better idea?
> If you're being strict it should presumably return NULL for the whole
> string. Or you'd need a "coalesce-to-this" parameter.
If the whole array is NULL it would return NULL, but that seems
unhelpful for a single element being NULL ...
regards, tom lane