PostgreSQL allows setting of a default value for a column, triggers are not needed for this task. See my reply to another node in this thread at Re: Re: Cleaning Up Apache::Session data.

Update: Triggers are what's desired here since he wants to update the rows ald set the time also.