set_slug.sql

CREATE OR REPLACE FUNCTION public.set_slug_from_name()
 RETURNS trigger
 LANGUAGE plpgsql
AS $function$
DECLARE
  _new record;
BEGIN
  _new := NEW;
  _new."slug" := public.slugify(NEW.name);
  RETURN _new;
END;
$function$

CREATE OR REPLACE FUNCTION public.slug_function()
 RETURNS trigger
 LANGUAGE plpgsql
AS $function$
      BEGIN
          NEW.slug := slugify(NEW.name);
          RETURN NEW;
      END;
  $function$

CREATE OR REPLACE FUNCTION public.slug_function_cats1()
 RETURNS trigger
 LANGUAGE plpgsql
AS $function$
      BEGIN
          NEW.slug := slugify(regexp_replace(NEW.name::text,  '\d+', '') || NEW.id::text);
          RETURN NEW;
      END;
  $function$