Re: Help with ADD COLUMN

On Sun, 2002-11-24 at 11:14, Hannu Krosing wrote:
> On Sun, 2002-11-24 at 08:34, Philip Warner wrote:
> > At 03:48 PM 23/11/2002 -0800, Christopher Kings-Lynne wrote:
> > >I assume that's the correct behaviour?  If they specify a default, the
> > >column should be auto-filled with that default, right?
> > 
> > Good question. We might want some input from other DBs; Dec RDB default 
> > existing rows to NULL irrespective of the 'DEFAULT' clause.
> 
> Also, how would I express a new column with default for which I _want_ 
> that column in old records to be NULL ?

Same way as you do now.  Add the column, then alter in the default.

-- 
Rod Taylor <rbt@rbt.ca>