Advertisement
Guest User

Untitled

a guest
Mar 5th, 2015
175
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.33 KB | None | 0 0
  1. CREATE OR REPLACE FUNCTION CHECK_SCHEDULE()
  2. RETURNS TRIGGER AS
  3. $BODY$
  4. BEGIN
  5. IF EXISTS(
  6. SELECT DAY, TIME FROM MEETING
  7. WHERE NEW.DAY = MEETING.DAY AND NEW.TIME > MEETING.TIME
  8. ) THEN
  9. RAISE EXCEPTION 'THERE IS A MEETING HAPPENING ON % % ', NEW.DAY, NEW.TIME;
  10. ELSE
  11. RETURN NEW;
  12. END IF;
  13. END;
  14. $BODY$ LANGUAGE PLPGSQL;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement