Re: function from rule - Mailing list pgsql-general

From Stephan Szabo
Subject Re: function from rule
Date
Msg-id 20011203111017.P93680-100000@megazone23.bigpanda.com
Whole thread Raw
In response to function from rule  (sara_software@hotmail.com (sara_software))
List pgsql-general
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.



pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: Problem with security
Next
From: "Peter Darley"
Date:
Subject: Re: Installing DBD::Pg module without Pg Database server