title: Firebird "For Each Row" trigger syntax
body: <p>There is confusion in the documentation and searching online about the support for statement and row level triggers. According to the documentation I've seen the latest version of Firebird supports both statement and row level triggers. </p>
  
  <p>Firebird supposedly supports SQL-92/99. The standard approach for this is to use "for each row" in the trigger SQL, however, this causes an error in firebird.</p>
  
  <p>Here is my statement level trigger, which works:</p>
  
  <pre><code>CREATE TRIGGER myExampleTrigger FOR myTable
      AFTER UPDATE
      AS
      BEGIN
         POST_EVENT 'testEvent';
      END;
  </code></pre>
  
  <p>Here is my row level trigger, which doesn't work:</p>
  
  <pre><code>CREATE TRIGGER myExampleTrigger FOR myTable
      AFTER UPDATE
      AS 
      FOR EACH ROW
      BEGIN
         POST_EVENT 'testEvent';
      END;
  </code></pre>
  
  <p>The statement-level trigger works to post an event for updates on myTable.  When I update multiple rows it will only post one event.</p>
  
  <p>What is the syntax for the trigger statement to get it to do a row-level trigger so that I can post an event FOR EACH ROW that is updated? </p>