2 versions of an entity worth distinct table?

From: gvim <gvimrc(at)gmail(dot)com>
To: pgsql <pgsql-general(at)postgresql(dot)org>
Subject: 2 versions of an entity worth distinct table?
Date: 2010-12-27 01:47:29
Message-ID: 4D17F031.5030603@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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. Technically it's a 1-to-many relationship so should be done this way but what is the general practice out there in such "max. 2" situations? Keeping them as:

Primary Email
Secondary Email

.... also preserves priority though not strictly normalised, I know.

gvim

Responses

Browse pgsql-general by date

  From Date Subject
Next Message AI Rumman 2010-12-27 05:33:13 Postgresql 9 connection problem
Previous Message gvim 2010-12-27 00:22:47 Standard schemas for common features?