Re: BUG #17147: Why concat_ws and concat is not immutable? - Mailing list pgsql-bugs

From RekGRpth
Subject Re: BUG #17147: Why concat_ws and concat is not immutable?
Date
Msg-id CAPgh2mJBakC5+2gHFQbaU1moCdvwYmee0MkxZ4sJYnzuwAcFKg@mail.gmail.com
Whole thread Raw
In response to Re: BUG #17147: Why concat_ws and concat is not immutable?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Thank you for the clarification.

пн, 16 авг. 2021 г. в 19:22, Tom Lane <tgl@sss.pgh.pa.us>:
>
> PG Bug reporting form <noreply@postgresql.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



pgsql-bugs by date:

Previous
From: Chuck Nellis
Date:
Subject: RE: Re: psql crash when running a procedure with an inout parameter and a commit
Next
From: Tom Lane
Date:
Subject: Re: psql crash when running a procedure with an inout parameter and a commit