{"author_name":"posturan","blog_url":"https://oboe2uran.hatenablog.com/","title":"PostgreSQL \u306e\u518d\u5e30SQL\u2192Array \u2192 mybatis \u3067\u53d6\u5f97","author_url":"https://blog.hatena.ne.jp/posturan/","type":"rich","description":"\u5148\u65e5\u306e\u4f8b\u3001 PostgreSQL \u306e\u518d\u5e30SQL \u3067\u8981\u7d20\u306e\u9023\u7d50\u7d50\u679c\u3092\u6c42\u3081\u308b\u3002 - Oboe\u5439\u304d\u30d7\u30ed\u30b0\u30e9\u30de\u306e\u9ed9\u793a\u9332 \u30c6\u30fc\u30d6\u30eb\u540d\uff1adivision id parent_id name 1 null A 2 1 B 3 2 C 4 2 D \u3053\u3053\u304b\u3089\u3001\u9023\u7d50\u6587\u5b57\u5217\u306e\u7d50\u679c\u3001id \u3068 name \"1\" \"1,2\" \"1,2,3\" \"1,2,4\"\"A\" \"A,B\" \"A,B,C\" \"A,B,D\"\u3068\u3001\u914d\u5217\u3068\u3057\u3066\u306e\u7d50\u679c\u3082\u6c42\u3081\u308b\uff33\uff31\uff2c\u306b\u3057\u307e\u3059\u3002 [1] [1,2] [1,2,3] [1,2,4][\"A\"] [\"A\", \"B\"] [\"A\", \"B\", \"C\"] [\"A\", \"B\", \"D\"]\u518d\u5e30\uff33\uff31\uff2c WITH REC\u2026","height":"190","url":"https://oboe2uran.hatenablog.com/entry/2019/03/14/151119","version":"1.0","published":"2019-03-14 15:11:19","provider_url":"https://hatena.blog","blog_title":"Oboe\u5439\u304d\u30d7\u30ed\u30b0\u30e9\u30de\u306e\u9ed9\u793a\u9332","provider_name":"Hatena Blog","html":"<iframe src=\"https://hatenablog-parts.com/embed?url=https%3A%2F%2Foboe2uran.hatenablog.com%2Fentry%2F2019%2F03%2F14%2F151119\" title=\"PostgreSQL \u306e\u518d\u5e30SQL\u2192Array \u2192 mybatis \u3067\u53d6\u5f97 - Oboe\u5439\u304d\u30d7\u30ed\u30b0\u30e9\u30de\u306e\u9ed9\u793a\u9332\" class=\"embed-card embed-blogcard\" scrolling=\"no\" frameborder=\"0\" style=\"display: block; width: 100%; height: 190px; max-width: 500px; margin: 10px 0px;\"></iframe>","image_url":null,"categories":["Java","SQL","mybatis"],"width":"100%"}