Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group