PostgreSQL if else code example

Example 1: select if then postgresql

SELECT field1, field2,
  CASE
    WHEN field1>0 THEN field2/field1
    ELSE 0
  END 
  AS field3
FROM test

Example 2: plpgsql if statement

if condition then
  statements;
else
  alternative-statements;
END if;

Example 3: 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 $$;

Example 4: postgress if

-- use postgress case

SELECT name, continent, indep_year,
    CASE WHEN indep_year < 1900 THEN 'before 1900'
         WHEN indep_year <= 1930 THEN 'between 1900 and 1930'
         ELSE 'after 1930' END
         AS indep_year_group
FROM countries
ORDER BY indep_year_group;