Answers for "plpgsql if statement"

SQL
-1

postgres if else

DO $$
DECLARE
  a integer := 10;
  b integer := 20;
BEGIN 
  IF a > b THEN
	RAISE NOTICE 'a is greater than b';
  END IF;

  IF a < b THEN
	RAISE NOTICE 'a is less than b';
  END IF;

  IF a = b THEN
	RAISE NOTICE 'a is equal to b';
  END IF;
END $$;
Posted by: Guest on May-29-2020
0

plpgsql if statement

if condition then
  statements;
else
  alternative-statements;
END if;
Posted by: Guest on November-21-2020

Code answers related to "SQL"

Browse Popular Code Answers by Language