Re: Trigger vs Rule

On 2 apr 2006, at 10.31, Ключников А.С. wrote:
> What is faster?
> One trigger with 1000 ELSE IF
> Or 1000 rules

Faster to write and easier to maintain would be to write a trigger
function in pl/pgsql which executes the right function dynamically:

CREATE OR REPLACE FUNCTION exec_device_type() RETURNS trigger AS $$
    EXECUTE "SELECT device_type" || OLD.type || "(OLD.id)";
$$ LANGUAGE plpgsql;

Best would probably be to refactor your device_typeN() functions into
one, that would take N as an argument.


Sincerely,

Niklas Johansson