Re: Accommodating alternative column values - Mailing list pgsql-general

From Christophe Pettus
Subject Re: Accommodating alternative column values
Date
Msg-id D9A3CE80-B0A8-4EF5-8FE8-BF4C70FA7306@thebuild.com
Whole thread Raw
In response to Accommodating alternative column values  (Rich Shepard <rshepard@appl-ecosys.com>)
Responses Re: Accommodating alternative column values
List pgsql-general

> On Jul 2, 2024, at 14:47, Rich Shepard <rshepard@appl-ecosys.com> wrote:
> Is there a way
> to accommodate multiple email addresses other than entering both with a
> forward slash separating them in the varchar(64) email address column?

If you are absolutely 100% sure there will never be any metadata associated with each email address (like a "valid"
flag),you can use TEXT[] array to store them.  Otherwise, it's best to move them into a table with a foreign key back
tothe owning record. 


pgsql-general by date:

Previous
From: Rich Shepard
Date:
Subject: Accommodating alternative column values
Next
From: Rich Shepard
Date:
Subject: Re: Accommodating alternative column values