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

On Jan 23, 2008 7:19 AM, Andreas <maps(dot)on(at)gmx(dot)net> wrote:

> Hi,
>
> I've got a table with a couple of boolean columns which represent
> attributes of entities.
> Now I need to list those entities with the attributes cumulated into one
> text-column.
> How could I do this?
>
> 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;