Re: Using random() in update produces same random value for all

[Ken Tanzer <ken.tanzer@xxxxxxxxx>]

On Sun, Jan 14, 2018 at 2:01 AM, Alex Magnum <magnum11200@xxxxxxxxx> wrote:

Hi,

i am trying to update a table with some random dates but that does not seem to work.

UPDATE table

   SET last_update=now()::date-(SELECT (random() * 5)::INTEGER + 1)

The updated field is always set to the same. Is there a way to make it random for every record?

I could run it through a function but I wonder if there is s simpler way.

 

I verified this with a SELECT, not an UPDATE, but I think leaving this as a simple _expression_ will do what you want.  Just leave out the SELECT:

 UPDATE table

   SET last_update=now()::date-((random() * 5)::INTEGER + 1)

Cheers,

Ken

--

AGENCY Software  

A Free Software data system

By and for non-profits

http://agency-software.org/

https://demo.agency-software.org/client

ken.tanzer@xxxxxxxxxxxxxxxxxxx

(253) 245-3801

Subscribe to the mailing list to

learn more about AGENCY or

follow the discussion.