Re: Function can not use the 'NEW' variable as a direct parameter inside trigger function?
Tom Lane <tgl@sss.pgh.pa.us>
From: Tom Lane <tgl@sss.pgh.pa.us>
To: intmail01 <intmail01@gmail.com>
Cc: pgsql-sql@lists.postgresql.org
Date: 2024-04-05T19:21:10Z
Lists: pgsql-sql
intmail01 <intmail01@gmail.com> writes: > 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. That doesn't look like NEW's fault. You lack a suitable function to be called. regards, tom lane