array_to_string

From: "Sabin Coanda" <sabin(dot)coanda(at)deuromedia(dot)ro>
To: pgsql-sql(at)postgresql(dot)org
Subject: array_to_string
Date: 2007-03-27 06:47:22
Message-ID: euaelf$28f8$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi there,

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'.

The function documentation doesn't explain this case.
So please tell me: is it the normal behavior or a bug ?

TIA,
Sabin

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Claus Guttesen 2007-03-27 12:37:51 select vs. select count
Previous Message Bruce Momjian 2007-03-27 01:50:30 Re: timestamp subtraction (was Re: [SQL] formatting intervals with to_char)