Re: 2 versions of an entity worth distinct table?

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: 2 versions of an entity worth distinct table?
Date: 2010-12-27 09:09:56
Message-ID: if9l53$dsg$1@dough.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

gvim wrote on 27.12.2010 02:47:
> If a table representing contact details can have 2 but no more than 2
> email addresses is it really worth factoring-out email addresses to a
> separate table.

If you are absolutely sure you will never have more than two, then I agree, you don't need to create a 1:N relationship for that.
Especially because guaranteeing that there will never be more than two in the N part is quite complicated.

Regards
Thomas

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2010-12-27 14:30:27 Re: Binary procedures for few types
Previous Message Radosław Smogura 2010-12-27 09:00:41 Binary procedures for few types