pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedBUG #17147: Why concat_ws and concat is not immutable?
3+ messages / 3 participants
[nested] [flat]
* BUG #17147: Why concat_ws and concat is not immutable?
@ 2021-08-16 12:03 PG Bug reporting form <noreply@postgresql.org>
2021-08-16 14:22 ` Re: BUG #17147: Why concat_ws and concat is not immutable? Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 3+ messages in thread
From: PG Bug reporting form @ 2021-08-16 12:03 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org; +Cc: rekgrpth@gmail.com
The following bug has been logged on the website:
Bug reference: 17147
Logged by: RekGRpth
Email address: rekgrpth@gmail.com
PostgreSQL version: 13.4
Operating system: docker alpine
Description:
Why concat_ws and concat is not immutable? And why they cannot be used in
generated always as?
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: BUG #17147: Why concat_ws and concat is not immutable?
2021-08-16 12:03 BUG #17147: Why concat_ws and concat is not immutable? PG Bug reporting form <noreply@postgresql.org>
@ 2021-08-16 14:22 ` Tom Lane <tgl@sss.pgh.pa.us>
2021-08-16 14:33 ` Re: BUG #17147: Why concat_ws and concat is not immutable? RekGRpth <rekgrpth@gmail.com>
0 siblings, 1 reply; 3+ messages in thread
From: Tom Lane @ 2021-08-16 14:22 UTC (permalink / raw)
To: rekgrpth@gmail.com; +Cc: pgsql-bugs@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: BUG #17147: Why concat_ws and concat is not immutable?
2021-08-16 12:03 BUG #17147: Why concat_ws and concat is not immutable? PG Bug reporting form <noreply@postgresql.org>
2021-08-16 14:22 ` Re: BUG #17147: Why concat_ws and concat is not immutable? Tom Lane <tgl@sss.pgh.pa.us>
@ 2021-08-16 14:33 ` RekGRpth <rekgrpth@gmail.com>
0 siblings, 0 replies; 3+ messages in thread
From: RekGRpth @ 2021-08-16 14:33 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>
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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2021-08-16 14:33 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2021-08-16 12:03 BUG #17147: Why concat_ws and concat is not immutable? PG Bug reporting form <noreply@postgresql.org>
2021-08-16 14:22 ` Tom Lane <tgl@sss.pgh.pa.us>
2021-08-16 14:33 ` RekGRpth <rekgrpth@gmail.com>
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