Question about array_to_string()'s behavior and the behavior might be changed in the future or not

From: "Egashira, Yusuke" <egashira(dot)yusuke(at)jp(dot)fujitsu(dot)com>
To: "'pgsql-general(at)postgresql(dot)org'" <pgsql-general(at)postgresql(dot)org>
Subject: Question about array_to_string()'s behavior and the behavior might be changed in the future or not
Date: 2019-01-17 06:50:30
Message-ID: 848B1649C8A6274AA527C4472CA11EDD5FA87F88@G01JPEXMBYT02
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I have a question about array_to_string().
I think array_to_string() concatenates always array elements from the "beginning" of the array elements and this rule will not be changed on the future minor releases.
Is my understanding correct?

For example, I understand that array_to_string() "never" output like following result now and in the future, is my understanding correct?

[Example] -> array_to_string(ARRAY[1, 2, 3, NULL, 5], ',', '*')
[Result] -> 2,1,3,*,5

Currently I use PostgreSQL 9.5.

Regards,

--
Yusuke, Egashira

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrew Gierth 2019-01-17 06:56:06 Re: Question about array_to_string()'s behavior and the behavior might be changed in the future or not
Previous Message Brent Wood 2019-01-17 03:17:23 Re: Can anyone please provide me list of customers using postgreSQL