Skip site navigation (1) Skip section navigation (2)

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

From: Andreas <maps(dot)on(at)gmx(dot)net>
To: ListaPostgre <pgsql-novice(at)postgresql(dot)org>
Subject: Need help with a function boolean --> text or array
Date: 2008-01-23 04:19:58
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice

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 
How could I do this?

Silly example:
table: pizzas
id   integer, 
name text,
has_olive   boolean,
has_cheese   boolean,
has_onion   boolean,
has_salami   boolean,
has_egg   boolean,
has_extra_hot_chilies boolean

My view should look like this:
id, name, addons
11, 'Salami',  'Cheese, Salami'
42, 'Fire',  'Cheese, Onion, Salami, Extra hot chilies'

Now I need a function that adds strings with commas in between (but not 
at the front or end) acording to the boolean-columns into one 
text-column that appears only in the view but isn't stored permanently.

The function has to work on the current record of the view but without 
having to give it every single boolean as parameter.
Something like this would be nice:
SELECT id, name, fctAddons() FROM pizzas;

I'm not very hot in stored procedures, yet.
Could someone give me a clue how to get this done?



pgsql-novice by date

Next:From: Vyacheslav KalininDate: 2008-01-23 05:03:39
Subject: Re: Need help with a function boolean --> text or array
Previous:From: Tom LaneDate: 2008-01-22 19:06:33
Subject: Re: domains, types, constraints

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group