When trying to create the following function:
CREATE OR REPLACE FUNCTION public.sp_busqueda_dgv_ta(
v_valor character varying
)
RETURNS table(ID INTEGER, NOMBRE VARCHAR(500))
LANGUAGE 'sql'
COST 100
VOLATILE
ROWS 1000
AS $BODY$
IF TRIM(V_VALOR) = '' THEN
SELECT ID_TIPO_ARTEFACTO ID,NOMBRE FROM tipo_artefacto;
ELSE
SELECT ID_TIPO_PRODUCTO ID,NOMBRE
FROM TIPO_ARTEFACTO
WHERE NOMBRE LIKE '%'|| TRIM(V_VALOR) ||'%';
END IF;
$BODY$;
I get the following error:
ERROR: syntax error on or near «IF» LINE 15: IF TRIM (V_VALOR) = '' THEN
Could you help me, thanks.