Postgres Pro
Downloads
Home   >   mailing lists

Re: Need help with a function boolean --> text or array - Mailing list pgsql-novice

From Andrej Ricnik-Bay
Subject Re: Need help with a function boolean --> text or array
Date
Msg-id b35603930801230024w72d74f2fmf5be6184531ee6e3@mail.gmail.com
Whole thread Raw
In response to Need help with a function boolean --> text or array  (Andreas <maps.on@gmx.net>)
Responses Re: Need help with a function boolean --> text or array  (Andreas <maps.on@gmx.net>)
List pgsql-novice
Tree view 
On 23/01/2008, Andreas <maps.on@gmx.net> wrote:
> My view should look like this:
> id, name, addons
> ...
> 11, 'Salami',  'Cheese, Salami'
> 42, 'Fire',  'Cheese, Onion, Salami, Extra hot chilies'
> ...
Looks primarily like a normalisation problem to me.  I'd be
going for a pizzaname-table, an ingredient-table and a pizza-table
that combines these m:n and then worry about the view ...


> Regards
> Andreas
Cheers,
Andrej

--
Please don't top post, and don't use HTML e-Mail :}  Make your quotes concise.

http://www.american.edu/econ/notes/htmlmail.htm

pgsql-novice by date:

Previous
From: Raimon Fernandez
Date:
Subject: using column alias to make operations
Next
From: "A. Kretschmer"
Date:
Subject: Re: using column alias to make operations