Re: Passing an argument to a trigger function using tg_argv

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Simon Connah <simon(dot)n(dot)connah(at)protonmail(dot)com>
Cc: "pgsql-novice(at)lists(dot)postgresql(dot)org" <pgsql-novice(at)lists(dot)postgresql(dot)org>
Subject: Re: Passing an argument to a trigger function using tg_argv
Date: 2021-04-01 05:25:22
Message-ID: CAKFQuwZOpbdRkQomYzPaU2T4NGWqC0dD+jHJavQ3843VNJYb0w@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On Wednesday, March 31, 2021, Simon Connah <simon(dot)n(dot)connah(at)protonmail(dot)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.

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Simon Connah 2021-04-01 10:12:20 Re: Passing an argument to a trigger function using tg_argv
Previous Message Simon Connah 2021-04-01 05:16:15 Re: Passing an argument to a trigger function using tg_argv