CODEWITHSUNDEEP
sqlpostgresqlrandom
Marcos Felipe Rezende Xavier
Marcos Felipe Rezende Xavier

Reputation: 35

Populate a numeric column with random values

This is my table: Table

I did this to populate it:

update AEROPORTO.RESERVA 
   set VALOR = random()*(5000-1500)+1500
where cod_reserva is not null

but random() has double precision and i what my values like this:

and round() doesn't use double precision.

I've tried to change the data type of the field Valor but didn't worked. Tried numeric, monetary and float.

I need to run a script that populates randomly this field with only 2 digits precision.

Upvotes: 1

Views: 72

Answers (1)

Ezequiel Tolnay
Ezequiel Tolnay

Reputation: 4582

There are two round functions, round(dp or numeric) returns integer, and round(v numeric, s int) that returns numeric. Try the following:

update AEROPORTO.RESERVA 
   set VALOR = round((random()*(5000-1500)+1500)::numeric, 2)
where cod_reserva is not null

Upvotes: 1

Related Questions