igeligel · June 17, 2019 10:34
diff --git a/any-case.sql b/any-case.sql
 SELECT *,
       CASE
           WHEN name = ANY(ARRAY['Airbus A333-300', 'Airbus A380-800']) THEN 'airplane'
           WHEN name = ANY(ARRAY['Volkswagen Golf', 'Porsche Cayenne']) THEN 'car'
           ELSE null
           END AS type
 FROM vehicles;
	SELECT *,
	CASE
	WHEN name = ANY(ARRAY['Airbus A333-300', 'Airbus A380-800']) THEN 'airplane'
	WHEN name = ANY(ARRAY['Volkswagen Golf', 'Porsche Cayenne']) THEN 'car'
	ELSE null
	END AS type
	FROM vehicles;