Skip to content
Snippets Groups Projects

Update 20230314062152-course-flavor.sql

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