Re: evaluating subselect for each row

On Jun 3, 2012, at 10:55 AM, Scott Ribe wrote:

> 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);

it may or may not be an option, but "update foo set bar=md5(bar)" is a pretty simple way to redact data.