{"id":1355,"date":"2018-10-01T22:41:59","date_gmt":"2018-10-01T20:41:59","guid":{"rendered":"http:\/\/oracle.malin.pl\/?p=1355"},"modified":"2018-10-01T22:41:59","modified_gmt":"2018-10-01T20:41:59","slug":"postgresql-sql-rozbicie-wartosci-po-przecinku-w-kolumnie-na-wiersze","status":"publish","type":"post","link":"https:\/\/oracle.malin.pl\/?p=1355","title":{"rendered":"PostgreSQL &#8211; SQL &#8211; rozbicie warto\u015bci po przecinku w kolumnie na wiersze"},"content":{"rendered":"<p>https:\/\/www.postgresql.org\/docs\/9.1\/static\/functions-string.html<\/p>\n<pre lang='SQL'>\r\n SELECT \r\n    ph_forms.ID, \r\n    ltrim(regexp_split_to_table(ph_forms.\"branchName\", E',')) AS split_branchName\r\nFROM ph_forms\r\n order by 1\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>https:\/\/www.postgresql.org\/docs\/9.1\/static\/functions-string.html SELECT ph_forms.ID, ltrim(regexp_split_to_table(ph_forms.&#8221;branchName&#8221;, E&#8217;,&#8217;)) AS split_branchName FROM ph_forms order by 1<\/p>\n","protected":false},"author":37,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":[],"categories":[257],"tags":[],"_links":{"self":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/1355"}],"collection":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/users\/37"}],"replies":[{"embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1355"}],"version-history":[{"count":1,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/1355\/revisions"}],"predecessor-version":[{"id":1356,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=\/wp\/v2\/posts\/1355\/revisions\/1356"}],"wp:attachment":[{"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1355"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1355"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oracle.malin.pl\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1355"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}