title: Syntax Error in Postgresql Trigger Function
body: <p>I'm brand new. The task was to create a trigger that will delete all dependent tuples from the depositor table when an account in a parent table is deleted. Here's what I've got so far. I keep getting a syntax error &quot;at or near 'cust_id'&quot; and I can't find it. Can you tell me if this trigger will do what I'm wanting it to do (delete the cust_id and account_number from the depositor table for the account that was deleted in the account table) and help me find the syntax error?</p>
  <pre><code>CREATE OR REPLACE FUNCTION Froehle_13_bankTriggerFunction()
  RETURNS TRIGGER
  LANGUAGE plpgsql
  AS
  $$
      BEGIN
          DELETE cust_id, account_number
          FROM depositor
          WHERE depositor.account_number = account.account_number;
      END;
  $$;
  </code></pre>