Re: Accommodating alternative column values

From: Christophe Pettus <xof(at)thebuild(dot)com>
To: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Accommodating alternative column values
Date: 2024-07-02 21:50:27
Message-ID: D9A3CE80-B0A8-4EF5-8FE8-BF4C70FA7306@thebuild.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> On Jul 2, 2024, at 14:47, Rich Shepard <rshepard(at)appl-ecosys(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rich Shepard 2024-07-02 21:57:46 Re: Accommodating alternative column values
Previous Message Rich Shepard 2024-07-02 21:47:12 Accommodating alternative column values