http://postgres.cz/index.php?action=history&feed=atom&title=Anonymizace_%C5%99et%C4%9Bzce 2026-06-02T19:07:36Z Historie editací této stránky MediaWiki 1.43.3 http://postgres.cz/index.php?title=Anonymizace_%C5%99et%C4%9Bzce&diff=523&oldid=prev 2012-02-23T14:26:09Z

<p>Založena nová stránka: &lt;pre&gt; CREATE OR REPLACE FUNCTION anonymize(text) RETURNS text AS $$ SELECT string_agg(CASE WHEN ascii(c) BETWEEN ascii(&#039;a&#039;) AND ascii(&#039;z&#039;) THEN substring(&#039;abcdefghijkl...</p> <p><b>Nová stránka</b></p><div>&lt;pre&gt;<br /> CREATE OR REPLACE FUNCTION anonymize(text)<br /> RETURNS text AS $$<br /> SELECT string_agg(CASE WHEN ascii(c) BETWEEN ascii(&#039;a&#039;) AND ascii(&#039;z&#039;) THEN substring(&#039;abcdefghijklmnopqrstuvwxyz&#039; FROM (random()*25)::int+1 for 1) <br /> WHEN ascii(c) BETWEEN ascii(&#039;A&#039;) AND ascii(&#039;Z&#039;) THEN substring(&#039;ABCDEFGHIJKLMNOPQRSTUVWXYZ&#039; FROM (random()*25)::int+1 for 1) <br /> WHEN c BETWEEN &#039;0&#039; AND &#039;1&#039; THEN ((c::int + (random()* 10)::int) % 10)::text <br /> ELSE c END,&#039;&#039;) <br /> FROM regexp_split_to_table($1,&#039;&#039;) c;<br /> $$ LANGUAGE sql;<br /> <br /> postgres=&gt; select anonymize(&#039;Jmenuji se Pavel Stehule a bydlim ve Skalici 12 (qjqj) *** jkDJ ***&#039;);<br /> anonymize <br /> ---------------------------------------------------------------------<br /> Jfwmuco gh Owmlx Ttsrlcb r vwtucl em Rnsoamq 72 (sxdp) *** koNF ***<br /> (1 row)<br /> &lt;/pre&gt;</div>

imported>Pavel