Re: Date column that defaults to 'now' - Mailing list pgsql-general

John Siracusa wrote:

 > On 1/5/04 4:29 PM, Michael Glaesemann wrote:
 >
 >>(If you're not the John Siracusa who writes for Ars Technica, the
 >>sentiment still holds. :) )
 >
 >
 > I am everywhere!
 >
 > (worked, thanks to both of you who replied :)

Anyway the two solution solve different problems:

1) DEFAULT now()
    you'll have the timestamp of transaction

2) DEFAULT timeofday()
    you'll have the timestamp of insertion



Regards
Gaetano Mendola