SQL - PostgreSQL, Function, Procedure
ยท
๐Ÿงฉ SQL
โœ… Function & ProcedureFunction๊ณผ Procedure๋Š” Database Object๋‹ค.์ด ๋‘˜์„ ์ด์šฉํ•˜๋ฉด ํŠน์ • ์ž‘์—…์„ ์ˆ˜ํ–‰ํ•˜๋Š” SQL๊ตฌ๋ฌธ์„ ์„ธํŠธ๋กœ ์บก์Аํ™” ํ•  ์ˆ˜ ์žˆ๋‹ค.(์žฌ์‚ฌ์šฉ ๊ฐ€๋Šฅ) โœ… FunctionFunction์€ ๋ฐ˜๋“œ์‹œ value๋ฅผ returnํ•œ๋‹ค.(Procedure์™€์˜ ๊ฐ€์žฅ ํฐ ์ฐจ์ด์ ) DML(Data Manipulation Language) Command์—์„œ ์‚ฌ์šฉํ•˜๊ธฐ ์œ„ํ•œ ๊ฒƒCREATE OR REPLACE FUNCTION hello_world ()RETURNS TEXT AS$$ SELECT 'hello_world';$$LANGUAGE SQL;LANGUAGE ํ‚ค์›Œ๋“œ๋กœ ์–ด๋–ค ์–ธ์–ด๋กœ Function์ด ์ž‘์„ฑ ๋˜์—ˆ๋Š”์ง€ ์ ์–ด์ค˜์•ผ ํ•œ๋‹ค. CREATE OR REPLACE FUNCTION ..