Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2014
    Posts
    1

    Red face 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 ?

    thanks

  2. #2
    Join Date
    Mar 2014
    Posts
    17
    Can you post the Function code which you have created so far

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •