I must be missing something obvious and I'm hoping someone can help me out. I have an existing table and add a new column:
ALTER TABLE xyz ADD COLUMN newcol TEXT; Next I want to set some default values to the new column. Because this code could potentially get executed later, I'm trying to be safe: UPDATE xyz SET newcol=function(other_column) WHERE newcol=null; UPDATE xyz SET newcol=function(other_column) WHERE newcol=''; Both of the above fail. What is the value in newcol? Thanks for any ideas. Doug This email was sent to you by Reuters, the global news and information company. To find out more about Reuters visit www.about.reuters.com Any views expressed in this message are those of the individual sender, except where the sender specifically states them to be the views of Reuters Limited. Reuters Limited is part of the Reuters Group of companies, of which Reuters Group PLC is the ultimate parent company. Reuters Group PLC - Registered office address: The Reuters Building, South Colonnade, Canary Wharf, London E14 5EP, United Kingdom Registered No: 3296375 Registered in England and Wales
