CREATE OR REPLACE FUNCTION public.fn_full_name(p_name text, p_surname text)
 RETURNS text
 LANGUAGE sql
 IMMUTABLE
AS $function$
  SELECT TRIM(COALESCE(p_name, '') || ' ' || COALESCE(p_surname, ''));
$function$
;