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