Yes, I'll probably be using default value on the insert but not certain yet. Thanks for the advice.
-Peder On Jan 4, 2008 4:19 PM, Daniel John Debrunner <[EMAIL PROTECTED]> wrote: > Peder Hultin wrote: > > FANTASTIC!!! This idea works perfectly; thanks so much! This has > > delayed me quite a > > number of hours. > > For the INSERT case are you using a trigger or will a simple DEFAULT > clause work for you? Is probably faster than a trigger. > > create table t (i int, ts timestamp default current timestamp); > insert into t(i) values 1; > select * from t; > > I |TS > -------------------------------------- > 1 |2008-01-04 16:17:53.89 > > > Dan. >
