Postgres Pro
Downloads
Home   >   mailing lists

[MASSMAIL] Function can not use the 'NEW' variable as a direct parameter inside trigger function? - Mailing list pgsql-sql

From intmail01
Subject [MASSMAIL] Function can not use the 'NEW' variable as a direct parameter inside trigger function?
Date
Msg-id CAKJANSC3sJ+aUrPptdh10+KG+eD9p6YHUJ5O-X5yr-+5v2VNZg@mail.gmail.com
Whole thread Raw
Responses Re: Function can not use the 'NEW' variable as a direct parameter inside trigger function?
List pgsql-sql
Tree view
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

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: Help with error date_trunc() function.
Next
From: Tom Lane
Date:
Subject: Re: Function can not use the 'NEW' variable as a direct parameter inside trigger function?