-- 7. Riadiaca struktura IF-THEN-ELSE CREATE OR REPLACE FUNCTION ifstat (date) RETURNS text AS $$ BEGIN IF EXTRACT(DAY FROM current_date) = 1 THEN RETURN '1st day of the Month'; ELSE RETURN 'Other day'; END IF; END; $$ LANGUAGE plpgsql;
-- 7. Riadiaca struktura IF-THEN-ELSE CREATE OR REPLACE FUNCTION ifstat (date) RETURNS text AS $$ BEGIN IF EXTRACT(DAY FROM current_date) = 1 THEN RETURN '1st day of the Month'; ELSE RETURN 'Other day'; END IF; END; $$ LANGUAGE plpgsql;
Comments
0 B
|👍
/👎
0 B
|👍
/👎