On 2020-Nov-19, Jaime Soler wrote:
> CREATE OR REPLACE FUNCTION public.tecnologia_index_func(nombre character
> varying, tipotec bigint)
> RETURNS text
> LANGUAGE sql
> IMMUTABLE
> AS $function$
> select tipotec || '_' || upper(sinacentos(trim(nombre)));
> $function$
This should be fixable by either schema-qualifying function
'sinacentos', or adding a SET search_path clause to the function.
CREATE OR REPLACE FUNCTION public.tecnologia_index_func(nombre character
varying, tipotec bigint)
RETURNS text
LANGUAGE sql
IMMUTABLE
AS $function$
select tipotec || '_' || upper(public.sinacentos(trim(nombre)));
$function$;