Re: array_to_string - Mailing list pgsql-sql

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.

--   Richard Huxton  Archonet Ltd