Re: 2 versions of an entity worth distinct table?

From: Radosław Smogura <mail(at)smogura(dot)eu>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: 2 versions of an entity worth distinct table?
Date: 2010-12-27 07:25:30
Message-ID: 201012270825.30089.mail@smogura.eu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

In this particular case it isn't worth to add separate table just for
additional e-mail.

gvim <gvimrc(at)gmail(dot)com> Monday 27 December 2010 02:47:29
> 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jasen Betts 2010-12-27 08:24:35 Re: why update is slower on my pc?
Previous Message AI Rumman 2010-12-27 05:33:13 Postgresql 9 connection problem