var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Trigger for updating a field
Hi guys , I'm a postgres beginner and i'm working on my first db.
I have a problem to create a function for a trigger that works on two tables.
In the first table 'site' I have two fields:
id(serial,pk) ,year(integer) .
in the second table "finds" I have 3 fields : id(serial,pk), id_site(integer) , f_year(integer).
the table 'site' is related with n record of table 'finds' and after update the table 'find' I need that the table site is updated with the minimum value of the related records of 'finds'.
Have anyone some suggestion to create the function ?
Can you post the Function code which you have created so far
Tags for this Thread