hey thanks mate, I have red that. But the actual data retirement seems to be combination of that and the SPI_get* functions. I'm still testing on it. By the way, if I can pass parameters that is out of the scope of sql statement??
------------------ Original ------------------ From: "Adrian Klaver"; Date: Friday, Apr 27, 2018 9:36 AM To: "a"<372660...@qq.com>; "pgsql-general"; Subject: Re: Parameter passing in trigger function write in C On 04/26/2018 06:13 PM, a wrote: > Hey everyone: > > I was request to write a trigger that perform the following function: > > 1, The trigger will be set to exam all statement that will result change > of datas > > 2, The trigger will exam three information other than the data updated > or inserted: user name, password and reasons of change > > 3, It will record down, in some format, the time and content of the change. > > Therefore, I would need some way of passing parameters into the trigger > function. Can anyone give me some instructions on how to do it or, if it > is possible?? https://www.postgresql.org/docs/10/static/trigger-interface.html -- Adrian Klaver adrian.kla...@aklaver.com
