Re: array_to_string - Mailing list pgsql-sql

From Richard Huxton
Subject Re: array_to_string
Date
Msg-id 46093147.6000209@archonet.com
Whole thread Raw
In response to Re: array_to_string  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: array_to_string
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


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: array_to_string
Next
From: Tom Lane
Date:
Subject: Re: array_to_string