u/Dismal_Cockroach_898

so im working on some school work related to postgreSQL and was able to figure things out and was nearing completion. Our professor had us making a trigger and function for a data base and needed a "proof of work" that both trigger and function work, and this is where i came to a stop.

when i came to test the trigger it gave me this error: An error has occurred: ERROR: control reached end of trigger procedure without RETURN

and searching online it said i just needed to add a return statement to my trigger so i did. but apparently that doesn't work as well and I got a syntax error instead

is there anything i did wrong in this query? my function is fine from what ive seen but this one isn't apparently??