On Fri, Jun 13, 2003 at 00:17:38 +0200, Mendola Gaetano <[EMAIL PROTECTED]> wrote: > "Henry House" <[EMAIL PROTECTED]> 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. ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
