From: Tom Lane <tgl@sss.pgh.pa.us>
To: intmail01 <intmail01@gmail.com>
cc: pgsql-sql@lists.postgresql.org
Subject: Re: Function can not use the 'NEW' variable as a direct parameter
 inside trigger function?
In-reply-to: 
 <CAKJANSC3sJ+aUrPptdh10+KG+eD9p6YHUJ5O-X5yr-+5v2VNZg@mail.gmail.com>
References: 
 <CAKJANSC3sJ+aUrPptdh10+KG+eD9p6YHUJ5O-X5yr-+5v2VNZg@mail.gmail.com>
Comments: In-reply-to intmail01 <intmail01@gmail.com>
	message dated "Fri, 05 Apr 2024 20:17:43 +0300"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <1404953.1712344870.1@sss.pgh.pa.us>
Date: Fri, 05 Apr 2024 15:21:10 -0400
Message-ID: <1404954.1712344870@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/1404954.1712344870%40sss.pgh.pa.us>
Precedence: bulk

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