Faz tempo q nao brinco com plpgsql mas ... nao esta faltando um begin
e um end ???
 
 
 
> Ainda necessitando de ajuda: O que está errado? 
> 
> 
> CREATE OR REPLACE FUNCTION teste() RETURNS
TRIGGER AS 
> 'DELETE FROM cliente WHERE cliente_id =
OLD.cliente_id;' 
> LANGUAGE plpgsql; 
> 
> CREATE
TRIGGER teste AFTER DELETE ON cliente_teste 
> FOR EACH ROW
EXECUTE PROCEDURE teste(); 
> 
> 
> ERROR: syntax
error at or near "DELETE" 
> CONTEXT: compile of
PL/pgSQL function "teste" near line 1 
> 
> 
> -- 
> Antonio Prado 
> 
> 
>
_______________________________________________ 
> pgbr-geral
mailing list 
> [email protected] 
>
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral 
> 

_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral

Responder a