On Monday, December 29, 2025, H <
agents@meddatainc.com> wrote:
I used the exact syntax you provided, however, I suspect that format() cannot be used in an argument in CREATE TRIGGER.
Oh, right. I was apparently overlooking the context and got tunnel vision around the “versioning” function call that isn’t really a call but rather a stored expression; and so the arguments must be simple literals (as documented).
In that case you do indeed need to do the work in the client since the server needs the final result handed to it.
You could also just create a wrapper function that calls versioning and has the two name part arguments as separate inputs.
David J.
