Re: Need help with a function boolean --> text or array

Uh,
  select id, name, (case when has_olive then 'Olive' else '' end) ||
                          (case when has_cheese then ', Cheese' else '' end) ||
                          (case when has_onion then ', Onion' else '' end) ||
                          (case when has_salami then ', Salami' else '' end) ||
                          (case when has_egg then ', Egg' else '' end) ||
                          (case when has_extra_hot_chilies then ', Extra hot chilies' else '' end) as addons
    from pizzas;