{"id":740,"date":"2019-04-08T11:15:37","date_gmt":"2019-04-08T02:15:37","guid":{"rendered":"https:\/\/www.udissoftlab.com\/?p=740"},"modified":"2019-04-08T11:20:11","modified_gmt":"2019-04-08T02:20:11","slug":"%e3%82%b9%e3%83%88%e3%82%a2%e3%83%89%e3%83%97%e3%83%ad%e3%82%b7%e3%83%bc%e3%82%b8%e3%83%a3","status":"publish","type":"post","link":"https:\/\/www.udissoftlab.com\/?p=740","title":{"rendered":"\u30b9\u30c8\u30a2\u30c9\u30d7\u30ed\u30b7\u30fc\u30b8\u30e3"},"content":{"rendered":"<h2>CREATE\u6587 \u4f8b<\/h2>\n<blockquote><p>&#8212;<br \/>\n&#8211;\u300c\u57fa\u672c\u300d\u30c6\u30fc\u30d6\u30eb\u304b\u3089\u300c\u30de\u30b9\u30bf_A\u300d\u30c6\u30fc\u30d6\u30eb\u306b\u30c7\u30fc\u30bf\u8ffd\u52a0<br \/>\n&#8212;<\/p>\n<p>CREATE OR REPLACE FUNCTION pro_cnv_base_to_mst_a()<br \/>\nRETURNS BOOLEAN AS $$<br \/>\nBEGIN<br \/>\nINSERT INTO &#8220;public&#8221;.mst_a(<br \/>\na_name &#8212; \u540d\u79f0<br \/>\n, user_id &#8212; \u5229\u7528\u8005ID<br \/>\n)<br \/>\nSELECT DISTINCT<br \/>\nformal_name &#8212; \u6b63\u5f0f\u540d\u79f0<br \/>\n, 999 &#8212; \u5229\u7528\u8005ID<br \/>\nFROM<br \/>\n&#8220;public&#8221;.base;<br \/>\nRETURN TRUE;<br \/>\nEXCEPTION WHEN OTHERS THEN<br \/>\nRETURN FALSE;<br \/>\nEND;<br \/>\n$$ LANGUAGE plpgsql;<\/p><\/blockquote>\n<h2>\u5b9f\u884c\u6587 \u4f8b<\/h2>\n<blockquote><p>SELECT * FROM pro_cnv_base_to_mst_a();<\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":"<p>CREATE\u6587 \u4f8b &#8212; &#8211;\u300c\u57fa\u672c\u300d\u30c6\u30fc\u30d6\u30eb\u304b\u3089\u300c\u30de\u30b9\u30bf_A\u300d\u30c6\u30fc\u30d6\u30eb\u306b\u30c7\u30fc\u30bf\u8ffd\u52a0 &#8212; CREATE OR REPLACE FUNCTION pro_cnv_base_to_mst_a( [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[5],"tags":[],"class_list":["post-740","post","type-post","status-publish","format-standard","hentry","category-postgresql"],"_links":{"self":[{"href":"https:\/\/www.udissoftlab.com\/index.php?rest_route=\/wp\/v2\/posts\/740","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.udissoftlab.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.udissoftlab.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.udissoftlab.com\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/www.udissoftlab.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=740"}],"version-history":[{"count":3,"href":"https:\/\/www.udissoftlab.com\/index.php?rest_route=\/wp\/v2\/posts\/740\/revisions"}],"predecessor-version":[{"id":743,"href":"https:\/\/www.udissoftlab.com\/index.php?rest_route=\/wp\/v2\/posts\/740\/revisions\/743"}],"wp:attachment":[{"href":"https:\/\/www.udissoftlab.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=740"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.udissoftlab.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=740"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.udissoftlab.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=740"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}