CREATE OR REPLACE FUNCTION teste() RETURNS TRIGGER AS
$BODY$
BEGIN
DELETE FROM cliente WHERE cliente_id = OLD.cliente_id;
RETURN new;
END;
$BODY$
LANGUAGE plpgsql VOLATILE;
2008/10/6 Antonio Prado <[EMAIL PROTECTED]>
> 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
>
--
José de Mello Júnior
41.9957-2007
_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
