Re: [SQL] DB porting questions...

2001-04-11 Thread Josh Berkus
Mike, You'll be overjoyed to know that both of your questions have simple answers. > 1) > I have a table: > create table a ( > t timestamp not null, > ... > ); > > I'm thinking that I can define a.t as not null default=now(). But > will this > work? That is, will it update a.t w

RE: [SQL] DB porting questions...

2001-04-11 Thread Michael Ansley
Title: RE: [SQL] DB porting questions... Hi, Jeff,   >>  1) >>  I have a table: >>      create table a ( >>          t   timestamp not null, >>          ... >>      ); >>  >>  I'm thinking that I can define a.t as not null