RE: sql/trigger question...arguments?
От | chris markiewicz |
---|---|
Тема | RE: sql/trigger question...arguments? |
Дата | |
Msg-id | 017601c02a58$d5208220$dbb846c6@cmarkiewicz обсуждение исходный текст |
Ответ на | sql/trigger question...arguments? ("chris markiewicz" <cmarkiew@commnav.com>) |
Ответы |
RE: sql/trigger question...arguments?
|
Список | pgsql-general |
hello. this is a follow-up to my previous question (shown below). i want to do the following...when a row is inserted into my PERSON table, i want to add a row to the RESOURCE table. i checked the documentation and tried many things...none seem to work. questions: 1. can a postgres trigger contain a insert/select/update/delete statement or can it contain only a function call? 2. my procedure, if i have to write one, does not return anything. how do i handle that in the RETURNS clause? if i tell it to return, for example, an int4, then try to create my trigger, it tells me that the sp has to return a value of type OPAQUE. 3. back to the original question, how do i pass variables? is it the :new.PersonID notation? thanks a lot. chris -----Original Message----- From: pgsql-general-owner@hub.org [mailto:pgsql-general-owner@hub.org]On Behalf Of chris markiewicz Sent: Friday, September 29, 2000 2:48 PM To: Postgres (E-mail) Subject: [GENERAL] sql/trigger question...arguments? 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
В списке pgsql-general по дате отправления: