What are you really want to do ? This is an exemple: CREATE FUNCTION myfunction () RETURNS trigger AS $$ BEGIN NEW.update_date = 'now'::date; RETURN NEW; END; $$ LANGUAGE plpgsql; CREATE TRIGGER set_update_date AFTER INSERT ON matable FOR EACH ROW EXECUTE PROCEDURE myfunction(); Le lundi 05 octobre 2009 à 14:36 +0530, Yogendra Kaushik a écrit : > Hi all's > i am working on an application in which we are using PostgreSql as an > database, i need to write trigger for my application. Can any one help me > how can i write it. > i have try to write it, but did not get success. > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php