On Sun, Jan 14, 2018 at 2:01 AM, Alex Magnum <magnum11...@gmail.com> 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/ <http://agency-software.org/>* *https://demo.agency-software.org/client <https://demo.agency-software.org/client>* ken.tan...@agency-software.org (253) 245-3801 Subscribe to the mailing list <agency-general-requ...@lists.sourceforge.net?body=subscribe> to learn more about AGENCY or follow the discussion.
