Thread: function from rule

I have a rule that calls a function on insert to a particular table.

I need this function to get the values from the insert function. so if
someone enters:

insert into this_table values(1,2,3);

I want to declare a variable and assign it the values in the insert
action.

How can I do this?

thx

On 30 Nov 2001, sara_software wrote:

> I have a rule that calls a function on insert to a particular table.
>
> I need this function to get the values from the insert function. so if
> someone enters:
>
> insert into this_table values(1,2,3);
>
> I want to declare a variable and assign it the values in the insert
> action.

I think you can get the specified data via NEW.<column> in the rule.