Advertisement
rafibatam

PL/pgSQL CASE Statement

Aug 1st, 2019
160
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. DO $$
  2. DECLARE
  3.     Snapdragon  INTEGER := 855;
  4.     MediatekP   INTEGER := 70;
  5.     Exynos      INTEGER := 9820;
  6. BEGIN
  7.     CASE
  8.    
  9.     WHEN Snapdragon > 845 THEN
  10.     RAISE NOTICE 'MI 9 uses a Snapdragon 855 processor';
  11.  
  12.     WHEN MediatekP < 60 THEN
  13.     RAISE NOTICE 'Realme U1 uses a Mediatek P70 processor';
  14.  
  15.     WHEN Exynos < 9810 THEN
  16.     RAISE NOTICE 'Samsung Galaxy S10+ uses a Exynos 9820 processor';
  17.  
  18.     ELSE
  19.     RAISE NOTICE 'Not Found';
  20.  
  21.     END CASE;
  22. END $$;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement