Hi Tom, > You can use ALTER TABLE SET DEFAULT to add the default after you add > the column. Works.
> Hmm ... I wonder why ADD COLUMN doesn't just call the SET DEFAULT > routine to handle adding the default ... I'm wondering too. But all programs do only those things they were told to do - mostly, not always ;-) Hi Stephan, > And, what do you mean by updates doing strange things? Follow-up-errors caused by updating an uninitialized array. Now it is clear why it couldn't work. Thanx and regards R. Lüttecke (IT) MICHAELTELECOM AG Bruchheide 34 49163 Bohmte +49 5471 8060 http://www.michael-telecom.de ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
