PostgreSQL\uc5d0\uc11c \ud55c\uae00 \ub2e8\uc5b4\uc5d0 \ub300\ud574 \ucd08\uc131\uc744 \uc5bb\ub294 \ubc29\ubc95\uc785\ub2c8\ub2e4.<\/P><\/p>\n
\r\nprepare \ucd08\uc131(text) as \r\n select case octet_length($1::char(1)) when 3 then \r\n case ((((get_byte(decode($1::char(1), 'escape'), 0) & 15) << 12) \r\n | ((get_byte(decode($1::char(1), 'escape'), 1) & 63) << 6) \r\n | ((get_byte(decode($1::char(1), 'escape'), 2) & 63))) - 44032) \/ 588 \r\n when 0 then E'\\xe3\\x84\\xb1' \r\n when 1 then E'\\xe3\\x84\\xb2' \r\n when 2 then E'\\xe3\\x84\\xb4' \r\n when 3 then E'\\xe3\\x84\\xb7' \r\n when 4 then E'\\xe3\\x84\\xb8' \r\n when 5 then E'\\xe3\\x84\\xb9' \r\n when 6 then E'\\xe3\\x85\\x81' \r\n when 7 then E'\\xe3\\x85\\x82' \r\n when 8 then E'\\xe3\\x85\\x84' \r\n when 9 then E'\\xe3\\x85\\x85' \r\n when 10 then E'\\xe3\\x85\\x86' \r\n when 11 then E'\\xe3\\x85\\x87' \r\n when 12 then E'\\xe3\\x85\\x88' \r\n when 13 then E'\\xe3\\x85\\x89' \r\n when 14 then E'\\xe3\\x85\\x8a' \r\n when 15 then E'\\xe3\\x85\\x8b' \r\n when 16 then E'\\xe3\\x85\\x8c' \r\n when 17 then E'\\xe3\\x85\\x8d' \r\n when 18 then E'\\xe3\\x85\\x8e' \r\n when -53 then $1::char(1) \r\n else '??' \r\n end \r\n else $1::char(1) \r\nend as initial; \r\n<\/pre>\n\uc2e4\ud589\uc740 execute \uba85\ub839\uc744 \ud65c\uc6a9\ud558\uba70 \uc608\ub97c \ub4e4\uc5b4 \uc544\ub798\uc640 \uac19\uc2b5\ub2c8\ub2e4.<\/P><\/p>\n
\r\nexecute \ucd08\uc131('\uac00\ub098\ub2e4');\r\n<\/pre>\n\uacb0\uacfc\ub294 '\u3131'\uc73c\ub85c \ub098\uc635\ub2c8\ub2e4.<\/P><\/p>\n","protected":false},"excerpt":{"rendered":"
PostgreSQL\uc5d0\uc11c \ud55c\uae00 \ub2e8\uc5b4\uc5d0 \ub300\ud574 \ucd08\uc131\uc744 \uc5bb\ub294 \ubc29\ubc95\uc785\ub2c8\ub2e4. prepare \ucd08\uc131(text) as select case octet_length($1::char(1)) when 3 then case ((((get_byte(decode($1::char(1), ‘escape’), 0) & 15)<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[],"class_list":["post-2351","post","type-post","status-publish","format-standard","hentry","category-programming"],"_links":{"self":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/2351","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2351"}],"version-history":[{"count":2,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/2351\/revisions"}],"predecessor-version":[{"id":2680,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/2351\/revisions\/2680"}],"wp:attachment":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2351"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2351"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2351"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}