Hi, In this particular case it isn't worth to add separate table just for additional e-mail. gvim <gvimrc@xxxxxxxxx> 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 -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
