Skip to content
Snippets Groups Projects

fix course

Merged Nathanael Santoso requested to merge fix-course into main
Compare and
4 files
+ 66
2
Preferences
Compare changes
Files
4
@@ -15,7 +15,7 @@ CREATE OR REPLACE FUNCTION assign_lecturer()
RETURNS TRIGGER
AS $assign$
BEGIN
IF NEW.lecturer is NULL OR NEW.lecturer = '' THEN
IF NEW.lecturer is NULL THEN
NEW.lecturer = (SELECT name FROM public."user" WHERE email = NEW.email);
END IF;
RETURN NEW;