Re: array_to_string

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Sabin Coanda" <sabin(dot)coanda(at)deuromedia(dot)ro>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: array_to_string
Date: 2007-03-27 14:49:50
Message-ID: 20090.1175006990@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

"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?

regards, tom lane

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Richard Huxton 2007-03-27 14:59:19 Re: array_to_string
Previous Message Jon Horsman 2007-03-27 14:27:18 Re: Foreign Unique Constraint