Tom Lane wrote:
> "Sabin Coanda" <sabin(dot)coanda(at)deuromedia(dot)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.
--
Richard Huxton
Archonet Ltd