Postgres Pro
Downloads
Home   >   mailing lists

array_to_string - Mailing list pgsql-sql

From Sabin Coanda
Subject array_to_string
Date
Msg-id euaelf$28f8$1@news.hub.org
Whole thread Raw
Responses Re: array_to_string  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] timestamp subtraction (was Re: formatting intervals with to_char)
Next
From: "Claus Guttesen"
Date:
Subject: select vs. select count