Re: function from rule

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: sara_software <sara_software(at)hotmail(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: function from rule
Date: 2001-12-03 19:10:55
Message-ID: 20011203111017.P93680-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Thomas T. Thai 2001-12-03 19:12:49 no quotes from pg_dump
Previous Message Stephan Szabo 2001-12-03 19:09:55 Re: Problem with security