CREATE OR REPLACE FUNCTION public.fn_admin_list_email_rules()
 RETURNS TABLE(id integer, event_type character varying, template_key character varying, email_field character varying, name_field character varying, language character varying, active boolean, mandatory boolean)
 LANGUAGE sql
AS $function$
    SELECT id, event_type, template_key, email_field, name_field, language, active, mandatory
    FROM public.email_dispatch_rules
    ORDER BY event_type, language;
$function$
;