Execute stored procedure based on conditions postgres

Question

I have a code like this :

create trigger audit_trigg_Test After insert on LOG 
for each row when(new.j='PR' and new.ds='FB') execute procedure ABC()
     when(new.j='PR' and new.ds='LNK')  execute procedure XYZ()


create or replace function ABC() returns trigger as $$
begin
--Stuff
end

create or replace function XYZ() returns trigger as $$
begin
--Stuff
end

The trigger should work on stored procedures based on the conditions

when(new.j='PR' and new.ds='FB') execute procedure ABC()
         when(new.j='PR' and new.ds='LNK')  execute procedure XYZ()

How can I do this?

Patrick · Accepted Answer · 2015-08-06 06:23:37Z

1

For this you need to define two separate triggers:

CREATE TRIGGER audit_trigg_Test_ABC
AFTER INSERT ON log 
FOR EACH ROW WHEN (NEW.j = 'PR' AND NEW.ds = 'FB') EXECUTE PROCEDURE ABC();

CREATE TRIGGER audit_trigg_Test_XYZ
AFTER INSERT ON log 
FOR EACH ROW WHEN (NEW.j = 'PR' AND NEW.ds = 'LNK') EXECUTE PROCEDURE XYZ();

You can use the WHEN clause to determine if a trigger is fired, but you cannot conditionally select a trigger function to call.

answered Aug 6, 2015 at 6:23

Patrick

33k7 gold badges73 silver badges102 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Execute stored procedure based on conditions postgres

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related