• Home
• us.fatehi
• schemacrawler-testdb
• 16.24.2
• source code
• 50_triggers_D.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

db.books.50_triggers_D.sql Maven / Gradle / Ivy

-- Triggers
-- PostgreSQL syntax

CREATE FUNCTION trg_authors() RETURNS trigger AS $trg_authors$
  BEGIN
    RAISE NOTICE 'LOGGED FROM TRIGGER';
    RETURN NEW;
  END;
$trg_authors$ LANGUAGE plpgsql
@

CREATE TRIGGER TRG_Authors BEFORE INSERT OR DELETE ON Authors
  FOR EACH ROW EXECUTE PROCEDURE trg_authors();
@