Thread

1. Function can not use the 'NEW' variable as a direct parameter inside trigger function?

   intmail01 <intmail01@gmail.com> — 2024-04-05T17:17:43Z

   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
   

2. Re: Function can not use the 'NEW' variable as a direct parameter inside trigger function?

   Tom Lane <tgl@sss.pgh.pa.us> — 2024-04-05T19:21:10Z

   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