Postgres Pro
Downloads
Home   >   mailing lists

Re: Creating trigger with optional arg? - Mailing list pgsql-admin

From David G. Johnston
Subject Re: Creating trigger with optional arg?
Date
Msg-id CAKFQuwYuYa_Nw7Swzrr6ETC9eDBBAd2PN8gkJ=HTz-PYBfYBhQ@mail.gmail.com
Whole thread Raw
In response to Creating trigger with optional arg?  (Wells Oliver <wells.oliver@gmail.com>)
Responses Re: Creating trigger with optional arg?  (Wells Oliver <wells.oliver@gmail.com>)
List pgsql-admin
Tree view
On Wed, Jul 22, 2020 at 9:49 AM Wells Oliver <wells.oliver@gmail.com> 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.

pgsql-admin by date:

Previous
From: Wells Oliver
Date:
Subject: Creating trigger with optional arg?
Next
From: Wells Oliver
Date:
Subject: Re: Creating trigger with optional arg?