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

From: "Andrej Ricnik-Bay" <andrej(dot)groups(at)gmail(dot)com>
To: Andreas <maps(dot)on(at)gmx(dot)net>
Cc: ListaPostgre <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Need help with a function boolean --> text or array
Date: 2008-01-23 08:24:23
Message-ID: b35603930801230024w72d74f2fmf5be6184531ee6e3@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On 23/01/2008, Andreas <maps(dot)on(at)gmx(dot)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

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message A. Kretschmer 2008-01-23 09:36:34 Re: using column alias to make operations
Previous Message Raimon Fernandez 2008-01-23 08:10:09 using column alias to make operations