Re: evaluating subselect for each row

From: Ben Chobot <bench(at)silentmedia(dot)com>
To: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
Cc: Postgresql General <pgsql-general(at)postgresql(dot)org>
Subject: Re: evaluating subselect for each row
Date: 2012-06-03 20:15:05
Message-ID: 2EB26121-7113-44CE-907B-A2C8DD5B83E8@silentmedia.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Matthias 2012-06-03 20:42:00 RLS & SEpgsql
Previous Message Scott Ribe 2012-06-03 17:55:55 evaluating subselect for each row