PostgreSQL Trigger and rows updated

[Albert <oo_O2_oo@xxxxxxxxxxx>]

am trying to update a table according to this trigger :

    CREATE TRIGGER alert 
    AFTER UPDATE ON cars
    FOR EACH ROW
    EXECUTE PROCEDURE update_cars();

Trigger Function :

    CREATE FUNCTION update_cars()
    RETURNS 'TRIGGER' 
    AS $BODY$
    BEGIN 
    IF (TG_OP = 'UPDATE') THEN
    UPDATE hello_cars SET status = new.status 
    WHERE OLD.ID = NEW.ID;
    END IF;
    RETURN NULL;
    END;
    $$ LANGUAGE plpgsql;

the trigger works fine. when cars table updated, the hello_cars table
updated but status column in each row is updated and contains same new
status ! it must be updated according to car ID.
i think my problem is in condition : WHERE OLD.ID = NEW.ID;
but can't tell what's wrong exactly

Thanks in advanced

--
View this message in context: http://postgresql.1045698.n5.nabble.com/PostgreSQL-Trigger-and-rows-updated-tp5608591p5608591.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general