DO $$

DECLARE

  x integer := 10;

  y integer := 20;

BEGIN 

  IF x > y THEN

   RAISE NOTICE 'x is greater than y';

  END IF;



  IF x < y THEN

   RAISE NOTICE 'x is less than y';

  END IF;



  IF x = y THEN

   RAISE NOTICE 'x is equal to y';

  END IF;

END $$;