Combining metavariables and table names

On Monday, December 29, 2025, H <agents(at)meddatainc(dot)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.