CREATE OR REPLACE FUNCTION do_something()
        RETURNS TRIGGER AS $$
    DECLARE
        engagement record;
    BEGIN
        SELECT code
        INTO engagement
        FROM "mainEngagement" me
        WHERE me.value = NEW.id;

        IF TG_OP = 'INSERT'
        THEN
            INSERT INTO engagement_details (code)
            values (
                case
                    when engagement is not null
                        then exists(select code from engagement where "value" = 'expected')
                    else false
                end
            );
        ELSE
            UPDATE engagement_details
            SET
                code = case
                    when engagement is not null
                        then exists(select 1 from engagement where "value" = 'expected')
                    else false
                end
            WHERE engagement_details.assessment_id = NEW.id;
        END IF;

        RAISE NOTICE 'Updated engagement_details: [%]', NEW;
        RETURN NEW;
    END;
    $$ LANGUAGE plpgsql;