Postgres Pro
Downloads
Home   >   mailing lists

Re: Passing an argument to a trigger function using tg_argv - Mailing list pgsql-novice

From David G. Johnston
Subject Re: Passing an argument to a trigger function using tg_argv
Date
Msg-id CAKFQuwZOpbdRkQomYzPaU2T4NGWqC0dD+jHJavQ3843VNJYb0w@mail.gmail.com
Whole thread Raw
In response to Re: Passing an argument to a trigger function using tg_argv  (Simon Connah <simon.n.connah@protonmail.com>)
Responses Re: Passing an argument to a trigger function using tg_argv  (Simon Connah <simon.n.connah@protonmail.com>)
List pgsql-novice
Tree view

On Wednesday, March 31, 2021, Simon Connah <simon.n.connah@protonmail.com> wrote:
‐‐‐‐‐‐‐ Original Message ‐‐‐‐‐‐

Sorry if I am misunderstanding. I'm still pretty new to PostgreSQL but the column actually is a bigint (well technically a bigserial) which is why I am confused.




‘The arguments are literal string constants.“ 

A column reference is simply not possible since arguments can only be “literal string constants”.

David J.

pgsql-novice by date:

Previous
From: Simon Connah
Date:
Subject: Re: Passing an argument to a trigger function using tg_argv
Next
From: Simon Connah
Date:
Subject: Re: Passing an argument to a trigger function using tg_argv