On Jan 23, 2008 7:19 AM, Andreas <
maps.on@gmx.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;