PG Bug reporting form <noreply@postgresql.org> writes: > The array_to_string function should have a volatility of immutable,
Nope. It invokes an arbitrary datatype I/O function, which might only be stable. As an example:
regression=# begin; BEGIN regression=*# select array_to_string(array[now()], ',');
That feels wrong. It's not like we are passing the "now()" function to the function and invoking it later. So far as array_to_string is concerned it is being given a literal value.
Nevermind. It's the internal timestampt to text cast I'm forgetting.