Gente, primeira vez que estou lidando com trigger... A tabela saldodiario tem o campo saldo. CONFIRMADO.
Erro de SQL: ERROR: syntax error at "saldo" DETAIL: Expected record variable, row variable, or list of scalar variables following INTO. CONTEXT: compilation of PL/pgSQL function "ins_mov" near line 8 Indicação de entrada : CREATE FUNCTION ins_mov() RETURNS trigger AS $$ DECLARE vsaldo NUMERIC; BEGIN -- Verifica se saldo deste dia á existe SELECT sd.saldo FROM saldodiario AS sd WHERE sd.conta = NEW.conta AND sd.data = NEW.data INTO saldo; IF vsaldo IS NULL THEN INSERT INTO saldodiario (conta,data,saldo) VALUES (NEW.conta,NEW.data,NEW.montante); ELSE UPDATE saldodiario AS sd SET sd.saldo = vsaldo+NEW.montante WHERE sd.conta=NEW.conta AND sd.data=NEW.data END IF; RETURN NULL; END; $$ LANGUAGE plpgsql; -- View this message in context: http://www.nabble.com/Trigger-Procedure---ERRO-tentando-INSERT-tp25925330p25925330.html Sent from the PostgreSQL - Brasil mailing list archive at Nabble.com. _______________________________________________ pgbr-geral mailing list pgbr-geral@listas.postgresql.org.br https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral