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