igeligel

SELECT SUM(price),
       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
GROUP BY vehicle_type;

igeligel

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;

igeligel

SELECT *,
       CASE
           WHEN name = 'Airbus A333-300' THEN 'airplane'
           WHEN name = 'Airbus A380-800' THEN 'airplane'
           WHEN name = 'Volkswagen Golf' THEN 'car'
           WHEN name = 'Porsche Cayenne' THEN 'car'
           ELSE null
           END AS type
FROM vehicles;

igeligel

SELECT * FROM vehicles
WHERE name = ANY (ARRAY['Airbus A333-300', 'Airbus A380-800']);

igeligel

ARRAY['Airbus A333-300', 'Airbus A380-800']

igeligel

VALUES ('Airbus A333-300'), ('Airbus A380-800')

igeligel

{
  "name": "Airbus A333-300",
  "type": "airplane"
}

igeligel

[
  {
    "name": "Airbus A333-300",
    "type": "airplane"
  },
  {
    "name": "Volkswagen Golf",
    "type": "car"
  },
  {

igeligel

const vehicles = [
  "Airbus A333-300",
  "Volkswagen Golf",
  "Porsche Cayenne",
  "Airbus A380-800"
];

const vehiclesWithTypes = vehicles.map(vehicle => {
  switch (vehicle) {
    case "Airbus A380-800":

igeligel

const booleanValue = true;
const baseFormat = {
  consumer_vat: consumerVat
};

const format = {
  a: true,
  ...(booleanValue && baseFormat)
};