g.copy vect=fields,myfields v.db.addcol myfields col="polynum integer" v.db.update myfields col=polynum val=42 where="label='V. White#1'" v.db.select myfields
Spearfish: adding new column, copying values from other table column with on the fly calculation:
g.copy vect=fields,myfields v.db.addcol myfields col="polynum integer" v.db.update myfields col=polynum qcol="cat*2" v.db.select myfields
Type cast (type conversion) of strings to double precision (unsupported by DBF driver):
v.db.update mygeodetic_pts col=zval qcol="CAST(z_value AS double precision)" \ where="z_value <> 'N/A'"
Last changed: $Date$