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?
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 Kalinin||Date: 2008-01-23 05:03:39|
|Subject: Re: Need help with a function boolean --> text or array|
|Previous:||From: Tom Lane||Date: 2008-01-22 19:06:33|
|Subject: Re: domains, types, constraints |