title: PostgreSQL Delete Trigger
body: <p>I´m creating a trigger on PGAdminIII where I want to delete the rows that have the foreign key on the other table. However I´m getting a Syntax error and I can´t find where the problem is:</p>
  
  <pre><code>CREATE TRIGGER clienteDelete
  BEFORE DELETE ON cliente
  FOR EACH ROW
  BEGIN
      DELETE FROM contacto WHERE contacto.id = OLD.contacto_idcontacto;
  END;
  
  ERROR:  syntax error at or near "BEGIN"
  LINE 4: BEGIN
          ^
  
  ********** Error **********
  
  ERROR: syntax error at or near "BEGIN"
  SQL state: 42601
  Character: 68
  </code></pre>
  
  <p>I´m not used to the syntax of triggers on Postgres but that´s what I know according to the SQL standard. Any help will be highly apreciated</p>