Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1sOlP1-0011tD-VI
	for pgsql-general@arkaria.postgresql.org; Tue, 02 Jul 2024 21:51:07 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.94.2)
	(envelope-from <pgsql-general-owner+archive@lists.postgresql.org>)
	id 1sOlOz-004S6C-Vd
	for pgsql-general@arkaria.postgresql.org; Tue, 02 Jul 2024 21:51:06 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps  (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <xof@thebuild.com>)
	id 1sOlOz-004S64-KO
	for pgsql-general@lists.postgresql.org; Tue, 02 Jul 2024 21:51:06 +0000
Received: from smtp105.iad3b.emailsrvr.com ([146.20.161.105])
	by makus.postgresql.org with esmtps  (TLS1.2) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.94.2)
	(envelope-from <xof@thebuild.com>)
	id 1sOlOt-0006AR-Qe
	for pgsql-general@postgresql.org; Tue, 02 Jul 2024 21:51:05 +0000
X-Auth-ID: xof@thebuild.com
Received: by smtp6.relay.iad3b.emailsrvr.com (Authenticated sender: xof-AT-thebuild.com) with ESMTPSA id 8191920090;
	Tue,  2 Jul 2024 17:50:58 -0400 (EDT)
Content-Type: text/plain;
	charset=us-ascii
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3774.600.62\))
Subject: Re: Accommodating alternative column values
From: Christophe Pettus <xof@thebuild.com>
In-Reply-To: <fd94aff-aec9-1b3d-64c6-16b0eaeccc58@appl-ecosys.com>
Date: Tue, 2 Jul 2024 14:50:27 -0700
Cc: pgsql-general@postgresql.org
Content-Transfer-Encoding: quoted-printable
Message-Id: <D9A3CE80-B0A8-4EF5-8FE8-BF4C70FA7306@thebuild.com>
References: <fd94aff-aec9-1b3d-64c6-16b0eaeccc58@appl-ecosys.com>
To: Rich Shepard <rshepard@appl-ecosys.com>
X-Mailer: Apple Mail (2.3774.600.62)
X-Classification-ID: 0bbbdcea-a31a-4593-8c02-4d5de955ae29-1-1
List-Id: <pgsql-general.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-general@lists.postgresql.org>
List-Owner: <mailto:pgsql-general-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-general>
Archived-At: <https://www.postgresql.org/message-id/D9A3CE80-B0A8-4EF5-8FE8-BF4C70FA7306%40thebuild.com>
Precedence: bulk



> 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 to the owning record.=