Ah yes.
ALTER TABLE blah ADD COLUMN whatever integer; UPDATE blah set whatever=1; ALTER TABLE blah ALTER COLUMN whatever SET NOT NULL; Produces the desired effect. I was thinking something along the lines of ALTER TABLE blah ADD COLUMN whatever integer not null default 1; should work, but the above is just as handy. ________________________________________________________________________ This email has been scanned for all viruses by the MessageLabs Email Security System. For more information on a proactive email security service working around the clock, around the globe, visit http://www.messagelabs.com ________________________________________________________________________ ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
