Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- create trigger chek_group_lessons
- BEFORE INSERT or UPDATE on sheldule
- for each row
- BEGIN
- if (SELECT * from sheldule where group_id = :NEW.group_id and day_id = :NEW.day_id, and day.i)
- THEN raise_application error (-20500, 'Group already had lesson in this moment');
- end if;
- end;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement