Re: Creating trigger with optional arg?

[Wells Oliver <wells.oliver@xxxxxxxxx>]

 I think this is a little different given I'm using the array TG_ARGV and not defined parameters in the signature though, correct?

On Wed, Jul 22, 2020 at 9:59 AM David G. Johnston <david.g.johnston@xxxxxxxxx> wrote:

On Wed, Jul 22, 2020 at 9:49 AM Wells Oliver <wells.oliver@xxxxxxxxx> wrote:

Is it possible to have a variable number of elements in TG_ARGV in a trigger?

https://www.postgresql.org/docs/12/sql-createfunction.html

see: default_expr

I would expect it to work though I have not tried it myself.

David J.

--

Wells Oliver
wells.oliver@xxxxxxxxx