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