2008/10/6, Antonio Prado <[EMAIL PROTECTED]>:
> Ainda necessitando de ajuda: O que está errado?
A definição da função?
>
>
> CREATE OR REPLACE FUNCTION teste() RETURNS TRIGGER AS
> 'DELETE FROM cliente WHERE cliente_id = OLD.cliente_id;'
> LANGUAGE plpgsql;
>
Creio que deva ser:
CREATE OR REPLACE FUNCTION teste() RETURNS TRIGGER AS
'
BEGIN
DELETE FROM cliente WHERE cliente_id = OLD.cliente_id;
RETURN NULL; -- será ignorado já que é um trigger "after"
END;
'
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
>
Osvaldo
_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
