{"id":231,"date":"2020-01-15T17:00:11","date_gmt":"2020-01-15T08:00:11","guid":{"rendered":"http:\/\/dev.e-luda.com\/dev-note\/?p=318"},"modified":"2020-01-15T17:00:11","modified_gmt":"2020-01-15T08:00:11","slug":"%eb%ac%b8%ec%9e%90%ec%97%b4%ec%9d%84-%eb%aa%a9%eb%a1%9d%ec%9c%bc%eb%a1%9c","status":"publish","type":"post","link":"http:\/\/dev.e-luda.com\/dev-note\/?p=231","title":{"rendered":"\ubb38\uc790\uc5f4\uc744 \ubaa9\ub85d\uc73c\ub85c"},"content":{"rendered":"\r\n<p>\ubb38\uc790\uc5f4 -> \ubaa9\ub85d<br>SELECT UNNEST(STRING_TO_ARRAY(&#8216;aa,bb,cc,cc,dd&#8217;,&#8217;,&#8217;))<\/p>\r\n\r\n\r\n\r\n<p>\ubaa9\ub85d -> \ubb38\uc790\uc5f4<br> SELECT ARRAY_TO_STRING(ARRAY_AGG(col),&#8217;,&#8217;)<br>   FROM generate_series(1,10) AS col <\/p>\r\n","protected":false},"excerpt":{"rendered":"<p>\ubb38\uc790\uc5f4 -> \ubaa9\ub85dSELECT UNNEST(STRING_TO_ARRAY(&#8216;aa,bb,cc,cc,dd&#8217;,&#8217;,&#8217;)) \ubaa9\ub85d -> \ubb38\uc790\uc5f4 SELECT ARRAY_TO_STRING(ARRAY_AGG(col),&#8217;,&#8217;) FROM generate_series(1,10) AS col<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[],"tags":[],"class_list":["post-231","post","type-post","status-publish","format-standard","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v18.6 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\ubb38\uc790\uc5f4\uc744 \ubaa9\ub85d\uc73c\ub85c - \ub9c8\ubc95\uc0ac\ub9ac\uc758\uac1c\ubc1c\ub178\ud2b8<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"http:\/\/dev.e-luda.com\/dev-note\/?p=231\" \/>\n<meta property=\"og:locale\" content=\"ko_KR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\ubb38\uc790\uc5f4\uc744 \ubaa9\ub85d\uc73c\ub85c - \ub9c8\ubc95\uc0ac\ub9ac\uc758\uac1c\ubc1c\ub178\ud2b8\" \/>\n<meta property=\"og:description\" content=\"\ubb38\uc790\uc5f4 -&gt; \ubaa9\ub85dSELECT UNNEST(STRING_TO_ARRAY(&#8216;aa,bb,cc,cc,dd&#8217;,&#8217;,&#8217;)) \ubaa9\ub85d -&gt; \ubb38\uc790\uc5f4 SELECT ARRAY_TO_STRING(ARRAY_AGG(col),&#8217;,&#8217;) FROM generate_series(1,10) AS col\" \/>\n<meta property=\"og:url\" content=\"http:\/\/dev.e-luda.com\/dev-note\/?p=231\" \/>\n<meta property=\"og:site_name\" content=\"\ub9c8\ubc95\uc0ac\ub9ac\uc758\uac1c\ubc1c\ub178\ud2b8\" \/>\n<meta property=\"article:published_time\" content=\"2020-01-15T08:00:11+00:00\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"wizardlee\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"http:\/\/dev.e-luda.com\/dev-note\/#website\",\"url\":\"http:\/\/dev.e-luda.com\/dev-note\/\",\"name\":\"\ub9c8\ubc95\uc0ac\ub9ac\uc758\uac1c\ubc1c\ub178\ud2b8\",\"description\":\"\ub2e4\ub978 \uc6cc\ub4dc\ud504\ub808\uc2a4 \uc0ac\uc774\ud2b8\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"http:\/\/dev.e-luda.com\/dev-note\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"ko-KR\"},{\"@type\":\"WebPage\",\"@id\":\"http:\/\/dev.e-luda.com\/dev-note\/?p=231#webpage\",\"url\":\"http:\/\/dev.e-luda.com\/dev-note\/?p=231\",\"name\":\"\ubb38\uc790\uc5f4\uc744 \ubaa9\ub85d\uc73c\ub85c - \ub9c8\ubc95\uc0ac\ub9ac\uc758\uac1c\ubc1c\ub178\ud2b8\",\"isPartOf\":{\"@id\":\"http:\/\/dev.e-luda.com\/dev-note\/#website\"},\"datePublished\":\"2020-01-15T08:00:11+00:00\",\"dateModified\":\"2020-01-15T08:00:11+00:00\",\"author\":{\"@id\":\"http:\/\/dev.e-luda.com\/dev-note\/#\/schema\/person\/7e381f3b46b7824adbe15ff43b53c42c\"},\"breadcrumb\":{\"@id\":\"http:\/\/dev.e-luda.com\/dev-note\/?p=231#breadcrumb\"},\"inLanguage\":\"ko-KR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\/\/dev.e-luda.com\/dev-note\/?p=231\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"http:\/\/dev.e-luda.com\/dev-note\/?p=231#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"http:\/\/dev.e-luda.com\/dev-note\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\ubb38\uc790\uc5f4\uc744 \ubaa9\ub85d\uc73c\ub85c\"}]},{\"@type\":\"Person\",\"@id\":\"http:\/\/dev.e-luda.com\/dev-note\/#\/schema\/person\/7e381f3b46b7824adbe15ff43b53c42c\",\"name\":\"wizardlee\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"http:\/\/dev.e-luda.com\/dev-note\/#personlogo\",\"inLanguage\":\"ko-KR\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/6eaa1dedfb9710f350bbf8ccb317e7cfa2a5a277b535c6558bc57169262ec430?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/6eaa1dedfb9710f350bbf8ccb317e7cfa2a5a277b535c6558bc57169262ec430?s=96&d=mm&r=g\",\"caption\":\"wizardlee\"},\"sameAs\":[\"http:\/\/dev.e-luda.com\/dev-note\"],\"url\":\"http:\/\/dev.e-luda.com\/dev-note\/?author=1\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\ubb38\uc790\uc5f4\uc744 \ubaa9\ub85d\uc73c\ub85c - \ub9c8\ubc95\uc0ac\ub9ac\uc758\uac1c\ubc1c\ub178\ud2b8","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"http:\/\/dev.e-luda.com\/dev-note\/?p=231","og_locale":"ko_KR","og_type":"article","og_title":"\ubb38\uc790\uc5f4\uc744 \ubaa9\ub85d\uc73c\ub85c - \ub9c8\ubc95\uc0ac\ub9ac\uc758\uac1c\ubc1c\ub178\ud2b8","og_description":"\ubb38\uc790\uc5f4 -> \ubaa9\ub85dSELECT UNNEST(STRING_TO_ARRAY(&#8216;aa,bb,cc,cc,dd&#8217;,&#8217;,&#8217;)) \ubaa9\ub85d -> \ubb38\uc790\uc5f4 SELECT ARRAY_TO_STRING(ARRAY_AGG(col),&#8217;,&#8217;) FROM generate_series(1,10) AS col","og_url":"http:\/\/dev.e-luda.com\/dev-note\/?p=231","og_site_name":"\ub9c8\ubc95\uc0ac\ub9ac\uc758\uac1c\ubc1c\ub178\ud2b8","article_published_time":"2020-01-15T08:00:11+00:00","twitter_card":"summary_large_image","twitter_misc":{"Written by":"wizardlee"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebSite","@id":"http:\/\/dev.e-luda.com\/dev-note\/#website","url":"http:\/\/dev.e-luda.com\/dev-note\/","name":"\ub9c8\ubc95\uc0ac\ub9ac\uc758\uac1c\ubc1c\ub178\ud2b8","description":"\ub2e4\ub978 \uc6cc\ub4dc\ud504\ub808\uc2a4 \uc0ac\uc774\ud2b8","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"http:\/\/dev.e-luda.com\/dev-note\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"ko-KR"},{"@type":"WebPage","@id":"http:\/\/dev.e-luda.com\/dev-note\/?p=231#webpage","url":"http:\/\/dev.e-luda.com\/dev-note\/?p=231","name":"\ubb38\uc790\uc5f4\uc744 \ubaa9\ub85d\uc73c\ub85c - \ub9c8\ubc95\uc0ac\ub9ac\uc758\uac1c\ubc1c\ub178\ud2b8","isPartOf":{"@id":"http:\/\/dev.e-luda.com\/dev-note\/#website"},"datePublished":"2020-01-15T08:00:11+00:00","dateModified":"2020-01-15T08:00:11+00:00","author":{"@id":"http:\/\/dev.e-luda.com\/dev-note\/#\/schema\/person\/7e381f3b46b7824adbe15ff43b53c42c"},"breadcrumb":{"@id":"http:\/\/dev.e-luda.com\/dev-note\/?p=231#breadcrumb"},"inLanguage":"ko-KR","potentialAction":[{"@type":"ReadAction","target":["http:\/\/dev.e-luda.com\/dev-note\/?p=231"]}]},{"@type":"BreadcrumbList","@id":"http:\/\/dev.e-luda.com\/dev-note\/?p=231#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"http:\/\/dev.e-luda.com\/dev-note"},{"@type":"ListItem","position":2,"name":"\ubb38\uc790\uc5f4\uc744 \ubaa9\ub85d\uc73c\ub85c"}]},{"@type":"Person","@id":"http:\/\/dev.e-luda.com\/dev-note\/#\/schema\/person\/7e381f3b46b7824adbe15ff43b53c42c","name":"wizardlee","image":{"@type":"ImageObject","@id":"http:\/\/dev.e-luda.com\/dev-note\/#personlogo","inLanguage":"ko-KR","url":"https:\/\/secure.gravatar.com\/avatar\/6eaa1dedfb9710f350bbf8ccb317e7cfa2a5a277b535c6558bc57169262ec430?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/6eaa1dedfb9710f350bbf8ccb317e7cfa2a5a277b535c6558bc57169262ec430?s=96&d=mm&r=g","caption":"wizardlee"},"sameAs":["http:\/\/dev.e-luda.com\/dev-note"],"url":"http:\/\/dev.e-luda.com\/dev-note\/?author=1"}]}},"_links":{"self":[{"href":"http:\/\/dev.e-luda.com\/dev-note\/index.php?rest_route=\/wp\/v2\/posts\/231","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/dev.e-luda.com\/dev-note\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/dev.e-luda.com\/dev-note\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/dev.e-luda.com\/dev-note\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/dev.e-luda.com\/dev-note\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=231"}],"version-history":[{"count":0,"href":"http:\/\/dev.e-luda.com\/dev-note\/index.php?rest_route=\/wp\/v2\/posts\/231\/revisions"}],"wp:attachment":[{"href":"http:\/\/dev.e-luda.com\/dev-note\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=231"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/dev.e-luda.com\/dev-note\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=231"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/dev.e-luda.com\/dev-note\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=231"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}