Function can not use the 'NEW' variable as a direct parameter inside trigger function?
intmail01 <intmail01@gmail.com>
From: intmail01 <intmail01@gmail.com>
To: pgsql-sql@lists.postgresql.org
Date: 2024-04-05T17:17:43Z
Lists: pgsql-sql
Hi,
Why a function can not pass the 'NEW' variable as a direct parameter ?
When I use myFunction(NEW) inside a trigger function an error appears :
pq_driver: [PGRES_FATAL_ERROR]ERROR: function myFunction(MyTableStruct)
does not exist
LINE 1: ...myFunction(NEW)...
^
HINT: No function matches the given name and argument types. You might
need to add explicit type casts.
I have to use trick by using a temporary variable to run the code :
theVariable MyTableStruct;
theVariable = NEW ;
myFunction(theVariable) ;
Thanks