Re: Proposal: pg_is_volatile function

2025-02-20 Thread Pavel Stehule
Hi > What we have speculated about in the past is extending EXPLAIN > so that it can be applied to ALTER TABLE and other complicated > utility commands, and then for ALTER TABLE one bit of info it would > give you is whether a table rewrite (or even a table scan) is > required. Obviously, that's

Re: Proposal: pg_is_volatile function

2025-02-20 Thread Tom Lane
Pavel Stehule writes: > čt 20. 2. 2025 v 13:48 odesílatel Andrew Farries > napsal: >> I believe the implementation of this function would be straightforward >> with a >> new function in `src/backend/utils/adt/misc.c` delegating to the existing >> `contain_volatile_functions_after_planning` functi

Re: Proposal: pg_is_volatile function

2025-02-20 Thread Pavel Stehule
Hi čt 20. 2. 2025 v 13:48 odesílatel Andrew Farries napsal: > I'd like to propose a new function `pg_is_volatile` that would test and > return > the volatility of its argument expression. Example uses of the function > would > be: > > pg_is_volatile(1) -> false > pg_is_volatile(random()) -> true