postgresql function 만들기 > 질문답변

• 목록

CREATE OR REPLACE FUNCTION getmaxmin(
    v1 NUMERIC,
    v2 NUMERIC,
    OUT min_value NUMERIC,
    OUT max_value NUMERIC)
AS
$$ BEGIN
    min_value := GREATEST(v1, v2);
    max_value := LEAST(v1, v2);
END; $$
LANGUAGE PLPGSQL;