lundi 19 décembre 2016

updating column not working in postgreSQL

I want to insert random integers between 9000 and 7500 into a column in PostgreSQL.So I used

update public.table set column_name = floor(random() * 9000 + 7500)::int;

But it is not updating the column.Any help is appreciated?




Aucun commentaire:

Enregistrer un commentaire