Hello everyone, I'm new to creating functions & triggers on postgresql
and am having trouble creating a trigger to update a record with the
modification date and the current user.
My code is below, but doesn't work. It hangs psql when I attempt to
modify the record. The function and trigger are created successfully.
CREATE FUNCTION email_mod_date() RETURNS OPAQUE AS '
UPDATE email SET m_date = current_date, m_by_user =
WHERE id = NEW.id;
CREATE TRIGGER email_mod_date
FOR EACH ROW
EXECUTE PROCEDURE email_mod_date();
Thanks for any help.
pgsql-novice by date
|Next:||From: Robert Morgan||Date: 2004-03-21 01:01:03|
|Subject: Re: connect from network PC |
|Previous:||From: Jay Davis||Date: 2004-03-20 21:32:08|
|Subject: How do you do a negative join?|