{"id":27,"date":"2012-03-07T14:28:16","date_gmt":"2012-03-07T14:28:16","guid":{"rendered":"http:\/\/blog.prolin.pl\/?p=27"},"modified":"2012-03-07T14:28:50","modified_gmt":"2012-03-07T14:28:50","slug":"kasowanie-duplikatow-w-postgresql","status":"publish","type":"post","link":"https:\/\/blog.prolin.pl\/?p=27","title":{"rendered":"Kasowanie duplikat\u00f3w w PostgreSQL"},"content":{"rendered":"<p>Kasowanie z tabeli aliases rekord\u00f3w, w kt\u00f3rych user_id i alias si\u0119 duplikuj\u0105 (jest &gt;1 rekord z tak\u0105 par\u0105):<\/p>\n<pre class=\"brush: sql; gutter: true\">delete from aliases where exists\r\n  (select &#039;x&#039; from aliases i where \r\n  i.user_id=aliases.user_id \r\n  and i.alias=aliases.alias and \r\n  i.oid&lt;aliases.oid);<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Kasowanie z tabeli aliases rekord\u00f3w, w kt\u00f3rych user_id i alias si\u0119 duplikuj\u0105 (jest &gt;1 rekord z tak\u0105 par\u0105): delete from aliases where exists (select &#039;x&#039; from aliases i where i.user_id=aliases.user_id and i.alias=aliases.alias and i.oid&lt;aliases.oid);<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16],"tags":[18,17],"class_list":["post-27","post","type-post","status-publish","format-standard","hentry","category-sql","tag-postgresql","tag-sql-2"],"_links":{"self":[{"href":"https:\/\/blog.prolin.pl\/index.php?rest_route=\/wp\/v2\/posts\/27","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.prolin.pl\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.prolin.pl\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.prolin.pl\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.prolin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=27"}],"version-history":[{"count":2,"href":"https:\/\/blog.prolin.pl\/index.php?rest_route=\/wp\/v2\/posts\/27\/revisions"}],"predecessor-version":[{"id":29,"href":"https:\/\/blog.prolin.pl\/index.php?rest_route=\/wp\/v2\/posts\/27\/revisions\/29"}],"wp:attachment":[{"href":"https:\/\/blog.prolin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=27"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.prolin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=27"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.prolin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=27"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}