sql/trigger question...arguments?

From: "chris markiewicz" <cmarkiew(at)commnav(dot)com>
To: "Postgres \(E-mail\)" <pgsql-general(at)postgresql(dot)org>
Subject: sql/trigger question...arguments?
Date: 2000-09-29 18:48:06
Message-ID: 016001c02a45$ce964b00$dbb846c6@cmarkiewicz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hello.

i am new to triggers. i am trying to write one that inserts a row into a
table (RESOURCE) everytime a new person (PERSON) is added to my db. the
problem is that i want to include some data from the PERSON insert in the
RESOURCE insert. (for example, the value of the PersonID field will be
entered into the ResourceID field.) how do i pass info to a trigger?

thanks
chris

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2000-09-29 19:26:50 Re: reldesc does not exit
Previous Message Stephan Szabo 2000-09-29 18:45:32 Re: Checking number of entries