{"id":4582,"date":"2017-02-22T11:00:19","date_gmt":"2017-02-22T02:00:19","guid":{"rendered":"http:\/\/www.gisdeveloper.co.kr\/?p=4582"},"modified":"2020-05-28T15:52:27","modified_gmt":"2020-05-28T06:52:27","slug":"postgresql%ec%9d%98-plpgsql-%ed%8a%9c%ed%86%a0%eb%a6%ac%ec%96%bc-4-if-%ec%a1%b0%ea%b1%b4%eb%ac%b8","status":"publish","type":"post","link":"http:\/\/www.gisdeveloper.co.kr\/?p=4582","title":{"rendered":"PostgreSQL\uc758 PL\/pgSQL \ud29c\ud1a0\ub9ac\uc5bc \u2013 4 : IF \uc870\uac74\ubb38"},"content":{"rendered":"

\uc548\ub155\ud558\uc138\uc694, GIS Developer \uae40\ud615\uc900\uc785\ub2c8\ub2e4. \uc774\ubc88 \uc7a5\uc5d0\uc11c\ub294 PL\/pgSQL\uc5d0\uc11c \uc81c\uacf5\ud558\ub294 \uc870\uac74\ubb38\uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4. \uc870\uac74\ubb38\uc740 \uc5b4\ub5a4 \uc870\uac74\uc5d0 \ub300\ud574 \uc2e4\ud589\ud560 \ucf54\ub4dc\ub97c \ubd84\ub9ac\ud558\uae30 \uc704\ud55c \ubaa9\uc801\uc73c\ub85c \uc0ac\uc6a9\ub429\ub2c8\ub2e4. <\/p>\n

PL\/pgSQL\uc5d0\uc11c \uc81c\uacf5\ud558\ub294 \uc870\uac74\ubb38\uc740 IF \ubb38\uacfc CASE \ubb38\uc73c\ub85c \ud06c\uac8c \uad6c\ubd84\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uba3c\uc800 IF \ubb38\uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n

IF \ubb38\uc758 \ubb38\ubc95\uc740 \uc544\ub798\uc640 \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n

\r\nIF <\uc870\uac74> THEN\r\n    <\ucc38\uc758 \uc2e4\ud589 \ucf54\ub4dc>\r\nELSE\r\n    <\uac70\uc9d3\uc758 \uc2e4\ud589 \ucf54\ub4dc>\r\nEND IF;<\/pre>\n
\ub9cc\uc57d <\uc870\uac74><\/strong>\uc774 \ubd80\ud569\ub418\ub294 \uac70\uc9d3(false)\uc774 \uc544\ub2cc \ucc38(true)\uc77c \uacbd\uc6b0 <\ucc38\uc758 \uc2e4\ud589 \ucf54\ub4dc><\/strong>\ub97c \uc2e4\ud589\ud558\uace0, <\uc870\uac74><\/strong>\uc774 \uac70\uc9d3\uc77c \uacbd\uc6b0 <\uac70\uc9d3\uc758 \uc2e4\ud589 \ucf54\ub4dc><\/strong>\ub97c \uc2e4\ud589\ud569\ub2c8\ub2e4. \uc870\uac74\uc5d0 \ub300\ud55c \uc2e4\ud589 \ucf54\ub4dc\ub294 1\uc904 \uc774\uc0c1\uc73c\ub85c \uad6c\uc131\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4.<\/p>\n
\uc77c\ub2e8 \uac04\ub2e8\ud55c \ucf54\ub4dc\ub97c \ud1b5\ud574 ELSE \uad6c\ubb38\uc774 \uc5c6\ub294 IF\ubb38\uc758 \uc608\ub97c \uc0b4\ud3b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n
\r\nDO $$\r\nDECLARE\r\n    a integer := 20;\r\n    b integer := 40;\r\n    c integer := 20;\r\nBEGIN \r\n    IF a > b THEN\r\n        RAISE NOTICE 'a\uac00 b\ubcf4\ub2e4 \ub354 \ud07d\ub2c8\ub2e4\ub2e4.';\r\n    END IF;\r\n \r\n    IF a < b THEN\r\n        RAISE NOTICE 'a\uac00 b\ubcf4\ub2e4 \ub354 \uc791\uc2b5\ub2c8\ub2e4.';\r\n    END IF;\r\n \r\n    IF a = b THEN\r\n        RAISE NOTICE 'a\uc640 b\uac00 \ub3d9\uc77c\ud569\ub2c8\ub2e4.';\r\n    END IF;\r\n    \r\n    IF a >= c THEN\r\n        RAISE NOTICE 'a\uac00 c\ubcf4\ub2e4 \ud06c\uac70\ub098 \uac19\uc2b5\ub2c8\ub2e4.';\r\n    END IF;\r\n    \r\n    IF a != b THEN\r\n        RAISE NOTICE 'a\uac00 b\uac00 \uac19\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.';\r\n    END IF;\r\n    \r\n    IF a != b AND a = c THEN\r\n        RAISE NOTICE 'a\uc640 b\uac00 \uac19\uc9c0 \uc54a\uace0 a\uc640 c\uac00 \uac19\uc2b5\ub2c8\ub2e4.';\r\n    END IF;\r\n    \r\n    IF a = b OR a = c THEN\r\n        RAISE NOTICE 'a\uc640 b\uac00 \uac19\uac70\ub098 a\uc640 c\uac00 \uac19\uc2b5\ub2c8\ub2e4.';\r\n    END IF;\r\n    \r\n    IF NOT (a = b OR a = c) THEN\r\n        RAISE NOTICE 'a\uc640 b\uac00 \uac19\uc9c0\uc9c0 \uc54a\uace0 a\uc640 c\ub3c4 \uac19\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.';\r\n    END IF;\r\nEND $$;<\/pre>\n
\ubcc0\uc218 a, b, c\ub97c \uac01\uac01 20, 40, 20\uc73c\ub85c \ucd08\uae30\ud654\ud558\uace0, \uac01 \uac12\uc5d0 \ub300\ud574 IF \ubb38\uc744 \ud1b5\ud574 \ube44\uad50\ud558\uace0 \uc788\uc2b5\ub2c8\ub2e4. \uba3c\uc800 7\ubc88 IF \ubb38\uc740 a\uac00 b \ubcf4\ub2e4 \ud06c\ub2e4\ub77c\ub294 \uc870\uac74\uc5d0 \ubd80\ud569\ud558\uc9c0 \uc54a\uc73c\ubbc0\ub85c 8\ubc88 \ucf54\ub4dc\ub97c \uc2e4\ud589\ud558\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. \ube44\uad50 \uc5f0\uc0b0\uc740 \ud06c\ub2e4, \uc791\ub2e4, \uac19\uac70\ub098 \ud06c\ub2e4, \uac19\uac70\ub098 \uc791\ub2e4, \uac19\uc9c0 \uc54a\ub2e4, \uac19\ub2e4\uc5d0 \ub300\ud574 \uac01\uac01 >, <, >=, <=, !=, =\uc785\ub2c8\ub2e4. \uc870\uac74\uc5d0 \ub300\ud574 AND\uc640 OR \uadf8\ub9ac\uace0 NOT\uc73c\ub85c \ubb36\uc5b4 \uc870\ud569\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. 27\ubc88\uc758 IF \ubb38\uc740 a\uc640 b\uac00 \uac19\uc9c0 \uc54a\uace0(AND) a\uc640 c\uac00 \uac19\uc740\uac00\ub77c\ub294 \uc870\uac74\uc73c\ub85c \ucc38\uc774\ubbc0\ub85c 28\ubc88 \ucf54\ub4dc\uac00 \uc2e4\ud589\ub429\ub2c8\ub2e4. 30\ubc88\uc758 IF\ubb38\uc740 a\uc640 b\uac00 \uac19\uac70\ub098(OR) a\uc640 c\uac00 \uac19\uc740\uac00\ub77c\ub294 \uc870\uac74\uc73c\ub85c \uac70\uc9d3\uc774\ubbc0\ub85c 31\ubc88\uc740 \uc2e4\ud589\ub418\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. \uadf8\ub9ac\uace0 33\ubc88\uc758 IF \ubb38\uc740 a\uc640 b\uac00 \uac19\uac70\ub098 a\uc640 c\uac00 \uac19\uc740\uac00\uc5d0 \ub300\ud55c \uc870\uac74\uc744 NOT\uc73c\ub85c \ubd80\uc815\ud558\uace0 \uc788\ub294\ub370, a\uc640 b\uac00 \uac19\uac70\ub098 a\uc640 c\uac00 \uac19\uc740\uac00\ub294 \ucc38(true)\uc774\uace0 \uc774\ub97c \ubd80\uc815\ud558\ubbc0\ub85c \uacb0\uad6d \uac70\uc9d3(false)\ub418\uc5b4 34\ubc88 \ucf54\ub4dc\ub294 \uc2e4\ud589\ub418\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4. \ucd5c\uc885 \uacb0\uacfc\ub294 \uc544\ub798\uc758 \ud654\uba74\uacfc \uac19\uc2b5\ub2c8\ub2e4.\n\n\n\n
\"\"<\/p>\n
ELSE \uad6c\ubb38\uae4c\uc9c0 \ud3ec\ud568\ud55c IF \ubb38\uc758 \uc608\ub97c \ubcf4\uba74 \uc544\ub798\uc640 \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n
\r\nDO $$\r\nDECLARE\r\n    a integer := 20;\r\n    b integer := 40;\r\nBEGIN \r\n    IF a > b THEN\r\n        RAISE NOTICE 'a\uac00 b\ubcf4\ub2e4 \ub354 \ud07d\ub2c8\ub2e4.';\r\n    ELSE\r\n        RAISE NOTICE 'a\uac00 b\ubcf4\ub2e4 \ub354 \ud06c\uc9c0 \uc54a\uc2b5\ub2c8\ub2e4.';\r\n    END IF;\r\nEND $$;<\/pre>\n
IF \ubb38\uc5d0\uc11c a\uac00 b\ubcf4\ub2e4 \ud070\uac00\uc5d0 \ub300\ud55c \uc870\uac74\uc774 \uac70\uc9d3(false)\uc774\ubbc0\ub85c ELSE \ubb38 \ub2e4\uc74c\uc758 \uc2e4\ud589 \ucf54\ub4dc\uac00 \uc2e4\ud589\ub418\ubbc0\ub85c \uadf8 \uacb0\uacfc\ub294 \ub2e4\uc74c\uacfc \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n
\"\"<\/p>\n
IF \ubb38\uc5d0 \ub300\ud55c \ub9c8\uc9c0\ub9c9 \uc608\ub85c \ub2e4\uc74c \ucf54\ub4dc\ub97c \uc0b4\ud3b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4.<\/p>\n
\r\nDO $$\r\nDECLARE\r\n    a integer := 20;\r\n    b integer := 40;\r\nBEGIN \r\n    IF a > b THEN\r\n        RAISE NOTICE 'a\uac00 b\ubcf4\ub2e4 \ub354 \ud07d\ub2c8\ub2e4.';\r\n    ELSEIF a = b THEN\r\n        RAISE NOTICE 'a\uc640 b\uac00 \uac19\uc2b5\ub2c8\ub2e4.';\r\n    ELSE\r\n        RAISE NOTICE 'a\uc640 b\uac00 \uac19\uc9c0 \uc54a\uace0, a\uac00 b\ubcf4\ub2e4 \ub354 \ud06c\uc9c0\ub3c4 \uc54a\uc2b5\ub2c8\ub2e4.';\r\n    END IF;\r\nEND $$;<\/pre>\n
ELSEIF \ubb38\uc744 \uc0ac\uc6a9\ud558\uace0 \uc788\ub294\ub370\uc694. \ub9cc\uc57d \uccab\ubc88\uc9f8 IF \ubb38\uc5d0 \ub300\ud55c \uc870\uac74\uc774 \uac70\uc9d3\uc774\uba74 \ub2e4\uc74c\uc758 ELSEIF \ubb38\uc758 \uc870\uac74\uc744 \uac80\uc0ac\ud558\uac8c \ub429\ub2c8\ub2e4. \uadf8\ub7f0\ub370 \uc774 ELSEIF \ubb38 \uc5ed\uc2dc \uac70\uc9d3\uc774\ub77c\uba74 \ub2e4\uc74c ELSEIF \ubb38\uc744 \uac80\uc0ac\ud558\uac8c\ub418\uace0, \ucd5c\uc885\uc801\uc73c\ub85c \uc5b4\ub5a0\ud55c \uc870\uac74\ub3c4 \ub9cc\uc871\ud558\uc9c0 \uc54a\ub294\ub2e4\uba74 ELSE \ubb38\uc758 \ucf54\ub4dc\uac00 \uc2e4\ud589\ub418\uac8c \ub429\ub2c8\ub2e4. \uc704\uc758 \ucf54\ub4dc\uc758 \uc2e4\ud589 \uacb0\uacfc\ub294 \uc544\ub798\uc640 \uac19\uc2b5\ub2c8\ub2e4.<\/p>\n
\"\"<\/p>\n","protected":false},"excerpt":{"rendered":"
\uc548\ub155\ud558\uc138\uc694, GIS Developer \uae40\ud615\uc900\uc785\ub2c8\ub2e4. \uc774\ubc88 \uc7a5\uc5d0\uc11c\ub294 PL\/pgSQL\uc5d0\uc11c \uc81c\uacf5\ud558\ub294 \uc870\uac74\ubb38\uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4. \uc870\uac74\ubb38\uc740 \uc5b4\ub5a4 \uc870\uac74\uc5d0 \ub300\ud574 \uc2e4\ud589\ud560 \ucf54\ub4dc\ub97c \ubd84\ub9ac\ud558\uae30 \uc704\ud55c \ubaa9\uc801\uc73c\ub85c \uc0ac\uc6a9\ub429\ub2c8\ub2e4. PL\/pgSQL\uc5d0\uc11c \uc81c\uacf5\ud558\ub294 \uc870\uac74\ubb38\uc740 IF \ubb38\uacfc CASE \ubb38\uc73c\ub85c \ud06c\uac8c \uad6c\ubd84\ud560 \uc218 \uc788\uc2b5\ub2c8\ub2e4. \uba3c\uc800 IF \ubb38\uc5d0 \ub300\ud574 \uc0b4\ud3b4\ubcf4\uaca0\uc2b5\ub2c8\ub2e4. IF \ubb38\uc758 \ubb38\ubc95\uc740 \uc544\ub798\uc640 \uac19\uc2b5\ub2c8\ub2e4. IF THEN ELSE END IF; \ub9cc\uc57d \uc774 \ubd80\ud569\ub418\ub294 \uac70\uc9d3(false)\uc774 \uc544\ub2cc \ucc38(true)\uc77c \uacbd\uc6b0 \ub97c … <\/p>\n
\ub354 \ubcf4\uae30 “PostgreSQL\uc758 PL\/pgSQL \ud29c\ud1a0\ub9ac\uc5bc \u2013 4 : IF \uc870\uac74\ubb38”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[50],"tags":[],"class_list":["post-4582","post","type-post","status-publish","format-standard","hentry","category-gisdev"],"_links":{"self":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/4582","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=4582"}],"version-history":[{"count":14,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/4582\/revisions"}],"predecessor-version":[{"id":9695,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/4582\/revisions\/9695"}],"wp:attachment":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4582"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4582"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4582"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}