postgresql添加随机分数的random 用法
update dws_declaration_tagged_goods_d set score=floor(1+random()*9)/100000+floor(1+random()*9)/10000+floor(1+random()*9)/1000+floor(1+random()*9)/100+floor(1+random()*9)/10;
update dws_declaration_tagged_goods_d set score=floor(1+random()*9)/1000+floor(1+random()*9)/100+floor(1+random()*9)/10;