Re: Accommodating alternative column values

[Christophe Pettus]

> On Jul 2, 2024, at 14:47, Rich Shepard <rshep...@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 to the owning record.