Re: BUG #17147: Why concat_ws and concat is not immutable?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: rekgrpth(at)gmail(dot)com
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: BUG #17147: Why concat_ws and concat is not immutable?
Date: 2021-08-16 14:22:06
Message-ID: 880379.1629123726@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

PG Bug reporting form <noreply(at)postgresql(dot)org> writes:
> Why concat_ws and concat is not immutable?

Those invoke datatype-specific output functions, which aren't guaranteed
to be immutable. Maybe ideally they would be, but we have too much
historical baggage --- for example, timestamp_out has always depended
on DateStyle.

regards, tom lane

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Chuck Nellis 2021-08-16 14:24:52 RE: Re: psql crash when running a procedure with an inout parameter and a commit
Previous Message Tom Lane 2021-08-16 13:48:24 Re: psql crash when running a procedure with an inout parameter and a commit