triggers - Inserted, Deleted tables in postgreSQL, like SQL Server? -


i want create trigger after inserted event, need data inserted in order register new table trigger in postgresql

in sql server capture these values inserted or deleted pseudo tables these tables exists in postgresql? or can do?

this trigger code

create trigger tri_compago   after insert   on matricula   each row   execute procedure fn_inscomppago();  create or replace function fn_inscomppago()   returns trigger $body$   declare   begin     insert compromisopago(codigotasa,descripcion,precio,fechavencimiento,codigomatricula)    select codigotasa,descripcion,precio,fechavencimiento,i.codigo    programacionpago pp join inserted on isnull(i.codigoconvenio,0) = isnull (pp.codigoconvenio,0)    , pp.codigopresentacion = i.codigopresentacion    pp.vigencia = 1 , i.vigencia = 1;     return null;   end; $body$   language plpgsql volatile   cost 100; alter function fn_inscomppago()   owner postgres; 

i have no idea how triggers work in sql server in postgresql, use old , new special variables:

new
data type record; variable holding new database row insert/update operations in row-level triggers. variable null in statement-level triggers , delete operations.

old
data type record; variable holding old database row update/delete operations in row-level triggers. variable null in statement-level triggers , insert operations.

so want @ new.codigo, new.codigoconvenio, new.codigopresentacion, , new.vigencia in case. you'd replace i.vigencia = 1 part of clause simple if i.vigencia = 1 conditional well.


Comments

Popular posts from this blog

c# - DetailsView in ASP.Net - How to add another column on the side/add a control in each row? -

javascript - firefox memory leak -

Trying to import CSV file to a SQL Server database using asp.net and c# - can't find what I'm missing -