RETURNS TRIGGER — for example CREATE OR REPLACE FUNCTION check_advisor_load() RETURNS TRIGGER ...

RETURNS VOID — trigger functions return nothing.

No RETURNS clause — CREATE TRIGGER holds the body directly.

RETURNS TABLE — trigger functions return the affected rows.