On Fri, Jun 13, 2003 at 00:17:38 +0200,
Mendola Gaetano <mendola@bigfoot.com> wrote:
> "Henry House" <hajhouse@houseag.uce-not-wanted-here.com> wrote:
> > Yes. Easy answer: use a column of type 'timestamp default now()'.
>
> With that default value you store the time
> stamp of transaction where the row was inserted. Immagine to insert
> inside the same transaction a lot of rows and this operation will take long
> 1 minute, you'll have all rows with the same time stamp instead of time
> stamp spreaded inside that minute, use timeofday instead.
You still may not want to use timeofday even for long transactions.
It depends on what the data really means to you.