I have a product table with a column barcode. After a product has been
deleted, I want to create a trigger to delete references to that product
in other tables. I've got the following trigger
ON TABLE product
FOR EACH ROW
Now, what I would ideally like to do is issue a simple sql delete command,
but I think I actually have to define a function (is this true?). Say I
do, then the rest of my trigger would look like
EXECUTE PROCEDURE someProc();
Now I need to pass somProc the barcode of the product I've just deleted.
How do I do this?
He who dies with the most toys ...
... still dies
pgsql-novice by date
|Next:||From: Jason Earl||Date: 2002-03-19 17:02:17|
|Subject: Re: Fwd: Query results|
|Previous:||From: Stein Eldar Johnsen||Date: 2002-03-19 15:28:23|
|Subject: undefined reference to `PgConnection type_info function'|