Error in PostgreSQL LANGUAGE SQL

1

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.

    
asked by nasck 21.02.2018 в 17:29
source

0 answers