From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: gergely.czuczy@harmless.hu
Subject: BUG #17360: array_to_string should be immutable instead of stable
Date: Mon, 10 Jan 2022 10:47:26 +0000
Message-ID: <17360-a50d754b72a97cad@postgresql.org> (raw)
The following bug has been logged on the website:
Bug reference: 17360
Logged by: Gergely Czuczy
Email address: gergely.czuczy@harmless.hu
PostgreSQL version: 13.3
Operating system: FreeBSD13
Description:
Hello,
The array_to_string function should have a volatility of immutable, it
perfectly fits the requirements in the documentation.
Where this comes to play is generated columns, when one wishes to have a
field something like GENERATED ALWAYS AS (array_to_string(ARRAY[selector,
'_domainkey', subdomain], '.')) STORED.
Reading the documentation I haven't found anything that would prevent the
function from being immutable, and enable this kind of usecases.
Best regards,
Gergely
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, gergely.czuczy@harmless.hu
Subject: Re: BUG #17360: array_to_string should be immutable instead of stable
In-Reply-To: <17360-a50d754b72a97cad@postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox