MIME-Version: 1.0
From: intmail01 <intmail01@gmail.com>
Date: Fri, 5 Apr 2024 20:17:43 +0300
Message-ID: 
 <CAKJANSC3sJ+aUrPptdh10+KG+eD9p6YHUJ5O-X5yr-+5v2VNZg@mail.gmail.com>
Subject: Function can not use the 'NEW' variable as a direct parameter inside
 trigger function?
To: pgsql-sql@lists.postgresql.org
Content-Type: multipart/alternative; boundary="000000000000cd515206155c9ffe"
Archived-At: 
 <https://www.postgresql.org/message-id/CAKJANSC3sJ%2BaUrPptdh10%2BKG%2BeD9p6YHUJ5O-X5yr-%2B5v2VNZg%40mail.gmail.com>
Precedence: bulk

--000000000000cd515206155c9ffe
Content-Type: text/plain; charset="UTF-8"

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

--000000000000cd515206155c9ffe
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr">Hi,<br><br>Why a function can not pass the &#39;NEW&#39; v=
ariable as a direct parameter ?<br>When I use myFunction(NEW) inside a trig=
ger function an error appears :<br><br>pq_driver: [PGRES_FATAL_ERROR]ERROR:=
 =C2=A0function myFunction(MyTableStruct) does not exist<br>LINE 1: ...myFu=
nction(NEW)... =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =
=C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=
=A0 ^<br>HINT: =C2=A0No function matches the given name and argument types.=
 You might need to add explicit type casts.<br><br>I have to use trick by u=
sing a temporary variable to run the code :<br><br>theVariable MyTableStruc=
t;<br>theVariable =3D NEW ;<br>myFunction(theVariable) ;<br><br>Thanks</div=
>

--000000000000cd515206155c9ffe--