Re: Column Specific Update Trigger Routine

This is what I have and it seems to work:

CREATE OR REPLACE FUNCTION holly_unlock() RETURNS trigger

    LANGUAGE plpgsql

    AS $$

    BEGIN

            IF OLD.password != NEW.password

            THEN

            UPDATE hms_mtusers_rw set loginfailedcount = 0 WHERE userid = OLD.userid and ownerid = OLD.ownerid;

            RETURN NEW;

            END IF;

        RETURN NULL; -- result is ignored since this is an AFTER trigger

    END;

$$;

Thanks !!

On 5/6/2010 4:12 PM, Plugge, Joe R. wrote:

You don't call the trigger procedure with the old and new as parameters

new and old are automatically created for the function  acct_unlock() 

CREATE TRIGGER check_lockout

    AFTER UPDATE ON acct_table

    FOR EACH ROW

    EXECUTE PROCEDURE acct_unlock();


Next the trigger function would look something like this

create or replace function acct_unlock()
returns trigger as
$$

if  (OLD.userid <> NEW.password)
    do  something
end if;

$$


keep in mind the acct_unlock must be  returns trigger

Then return either NEW or the OLD record 
OLD if  not changing the record or NEW if  the updated values are to be stored in the table.



All legitimate Magwerks Corporation quotations are sent in a .PDF file attachment with a unique ID number generated by our proprietary quotation system. Quotations received via any other form of communication will not be honored.

CONFIDENTIALITY NOTICE: This e-mail, including attachments, may contain legally privileged, confidential or other information proprietary to Magwerks Corporation and is intended solely for the use of the individual to whom it addresses. If the reader of this e-mail is not the intended recipient or authorized agent, the reader is hereby notified that any unauthorized viewing, dissemination, distribution or copying of this e-mail is strictly prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and destroy all occurrences of this e-mail immediately.
Thank you.