Fórum Ajuda passa valores para variavel #27115

CREATE OR REPLACE FUNCTION gera_voucher(text,text)
RETURNS text AS
$BODY$ 
DECLARE

xcodlote TEXT=´´;

BEGIN

        xcodlote = ´select codlote from lotecontabilidade where lote=$1´;
        
       

        if xcodlote = ´1.1´ then 
         delete from temp_voucher;        
          
        end if;   
  

RETURN xcodlote;
END
 $BODY$
  LANGUAGE ´plpgsql´ VOLATILE STRICT;
ALTER FUNCTION gera_voucher(text) OWNER TO postgres;