Adding serial key

This method is not efficient as the method Jonathan used, since this will read the data multiple times to make the conversion where Jonathan's method will just do it once. > > Y'all > > Jonathan properly chided me for not considering that adding a new column to > a table will result in it having null values - hence when you add an > integer and then convert it to serial you'll get a non-unique value error. > _____________________________________________________________________________ Jack Parker - Hewlett Packard, DMD/IS Boise, Idaho, USA jparker@hpbs3645.boi.hp.com _____________________________________________________________________________ If anything can go wrong, fix it. To hell with Murphy. _____________________________________________________________________________ Any opinions expressed herein are my own and not those of my employers. _____________________________________________________________________________