Re: evaluating subselect for each row - Mailing list pgsql-general

From Ben Chobot
Subject Re: evaluating subselect for each row
Date
Msg-id 2EB26121-7113-44CE-907B-A2C8DD5B83E8@silentmedia.com
Whole thread Raw
In response to evaluating subselect for each row  (Scott Ribe <scott_ribe@elevated-dev.com>)
List 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.

pgsql-general by date:

Previous
From: utsav
Date:
Subject: TYPE TABLE OF NUMBER
Next
From: Matthias
Date:
Subject: RLS & SEpgsql