evaluating subselect for each row - Mailing list pgsql-general

From Scott Ribe
Subject evaluating subselect for each row
Date
Msg-id 697D10B2-17F8-4D80-99B8-09452E7E7F99@elevated-dev.com
Whole thread Raw
Responses Re: evaluating subselect for each row
List pgsql-general
As part of anonymizing some data, I want to do something like:

update foo set bar = (select bar2 from fakes order by random() limit 1);

But of course, that sets them all to the same value, whereas I want them all different.

--
Scott Ribe
scott_ribe@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice





pgsql-general by date:

Previous
From: Tim Uckun
Date:
Subject: Re: Updateable Views or Synonyms.
Next
From: utsav
Date:
Subject: TYPE TABLE OF NUMBER