triggers

Hi, I have a problem I am using postgresql database and I want to enforce
>triggers between my related tables ( tables with relationship), one
table
>has a foreign key and the other the a primary key, I would like to use
>triggers to update, delete, and insert in this tables but the table with
the
>foreign key should first check in the other table before any action is
>taken, Which is the simplest sql or C language script can I use to
enforce
>triggers within my tables, please demonstrate a simple scenerio thanks

<br><br><br>Martin Wainaina Kuria
Programmer/Database Administrator
Bsc. Computer Science
Kenyaweb.com Ltd
www.kenyaweb.com

_________________________________________________________________
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp