DB Wiki

CREATE [OR REPLACE] FUNCTION fnc_nme()
   RETURNS <return type> 
   LANGUAGE plpgsql
AS $$
DECLARE 
-- Variables
BEGIN
 -- Logic
END; $$

CREATE [OR REPLACE] PROCEDURE prc_nme()
LANGUAGE plpgsql
AS $$
DECLARE
-- Variables
BEGIN
-- Body
END; $$

IF condition_1 THEN
  statement_1;
ELSIF condition_n THEN
  statement_n;
ELSE
  else-statement;
END IF;

CASE RATE
  WHEN 'a' THEN variable = 1;
  WHEN 'b' THEN variable = 2;
  ELSE PRICE_SEGMENT = 0;
END CASE;

CASE 
  WHEN total > 200 THEN variable = 'PLATINUM' ;
  WHEN total > 100 THEN variable = 'GOLD' ;
  ELSE variable = 'SILVER' ;
END CASE;

LOOP
   -- Statements
   IF condition THEN
      EXIT;
   END IF;
END LOOP;

WHILE CONDITION LOOP
   -- Statements;
END LOOP;

FOR loop_counter in [ reverse ] FROM.. TO [ by step ] LOOP
    -- Statements
END LOOP