Re: Inheritance & multiple-value fields

From: Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Inheritance & multiple-value fields
Date: 2003-08-02 22:09:12
Message-ID: 1059862152.24818.76.camel@haggis
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Sat, 2003-08-02 at 15:26, Vernon Smith wrote:
> We usually use another table for a multi-valued field. Is possible
> having a single multi-valued field table for all tables in the
> same heredity, other than having a multi-valued table for every
> single tables in the heredity?

Sure: Pick, now known as D3.
http://www.rainingdata.com/products/dbms/d3/index.html

However, that breaks the cardinal rule of relational DB design:
http://www.databasejournal.com/sqletc/article.php/26861_1428511_4

--
+-----------------------------------------------------------------+
| Ron Johnson, Jr. Home: ron(dot)l(dot)johnson(at)cox(dot)net |
| Jefferson, LA USA |
| |
| "I'm not a vegetarian because I love animals, I'm a vegetarian |
| because I hate vegetables!" |
| unknown |
+-----------------------------------------------------------------+

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2003-08-02 23:47:14 Re: plPHP -- sort of an announcement.. but not commercial
Previous Message Ron Johnson 2003-08-02 22:02:46 Re: Domains (Was [PERFORM] Views With Unions)