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 ) id 1vAqpk-006Zut-32 for pgsql-general@arkaria.postgresql.org; Mon, 20 Oct 2025 14:25:59 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1vAqpi-000uFD-Nx for pgsql-general@arkaria.postgresql.org; Mon, 20 Oct 2025 14:25:57 +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 ) id 1vAqpi-000uF4-BU for pgsql-general@lists.postgresql.org; Mon, 20 Oct 2025 14:25:57 +0000 Received: from mail-oa1-x36.google.com ([2001:4860:4864:20::36]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vAqpf-002nou-2P for pgsql-general@lists.postgresql.org; Mon, 20 Oct 2025 14:25:56 +0000 Received: by mail-oa1-x36.google.com with SMTP id 586e51a60fabf-3c9c379af8aso1101231fac.1 for ; Mon, 20 Oct 2025 07:25:55 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1760970355; x=1761575155; darn=lists.postgresql.org; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :from:to:cc:subject:date:message-id:reply-to; bh=tDFWkZbS0EdvMYwnmM15PqpgG9KEA2exum9QREnm9OQ=; b=IqwwRz2nzMW/rrKIYkomM8HQp50sQhWSgPBJ2sftA8aLNvBfG04ubqBf0ZEtQghXKW /UJh+zyk0dyV3BxcxEAbwWejvOkHBrx2SFHVjZ02Rg3m3jMBR8nZe3kACyp5hhdPaQYQ MggITvlYtYsZXu+fqYUmQkJph1R1DzfTOwkELInjeiD5rLfXrR2X+GsTxz1dOH1HBb3e dTLArD8+bGql7R7qc0FkTkfRt/4UpQJB/qQryRPR3gp3inD08nzPeZJJ5ic/D1RBlKds 6/BmIwpD5q6SGsAF3x8af4ln3BrdBRvmzBiAA1N/wJPmSFscqa6NGNOpvdoROCeZdoMm E3Ag== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1760970355; x=1761575155; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=tDFWkZbS0EdvMYwnmM15PqpgG9KEA2exum9QREnm9OQ=; b=t9HCM0g5RI1lSDRz/o3RoEG718uvyYWklSU31Ovkuem6l+FFefdKHDhCmXkexKSWYf KIqXbXmNvy3Pv9RVxssmk49K/xCwRWu25lnDIWc6vMOMIq9btfrZ0MI24SSMAZcWWiyw JCHRhVbzTd5iCeZY17UXp+9pvXNmiTpE/qu61R+itIrLoIDQDZgqrCLY0sF3ojvGLtZN Ne0Oh0Gf+88MojiQTTVN7R7FUPE1i0k9/OVk4QA5y0eYtrdqjxzXZh36CF2Qr7/Bhuhr Lml60k9fHW6ZbpYYOmRtiu4h4aFmr4tFiPGgsWAi2GKukYlPqAIxAATuLvwqsN+DWwIL 4mbw== X-Gm-Message-State: AOJu0Yz6LUJrGk7RT+3uiUCcRfhxypsy6wYaVyj0Qkv92aG288oxJv0l m6YK4xH9Mu0TLFBJ7tUJDtzZnmIcp4I0LjeMmfYypVR5DSZFCTzGnnEP6LMlQ1HnyaCbRgQ20mI RFN9nzSW9yF+qVbSUpZ1txPHeNu84Q6sXkdne X-Gm-Gg: ASbGnctGaH0GKgMoxI2FQL952YWg0bQUhIPK0MdAZUIG7/kmLNGabIWxzjMUf/BPicp iNNwy87pby+DGXlwafii6zIcV34EmWkaNr+MLotMXduvwugkyWpsR+4zotyualIeXRqBozW7vfN VYC4tXqHgkCi7xv+TnnCz3WZvrFHjLjir950yX9Fx1cOBNnv/K5s4E4QNeFas5DAkQJwdNePHgU 1ALl/S1Bt1autFgtvi92Uu03Uy0DjGyGqr//uG6pXFuc+KwkETFq4LE+bhCfw== X-Google-Smtp-Source: AGHT+IE/NyXMck3u8TRpbCWBPxwHLWKkt4Bi7tKVoEyIR0/qMWFBO7QW4zWwEySNZK/pu4WJ11Gbx3Pui3D7cy3sVL8= X-Received: by 2002:a05:6870:6009:10b0:3c9:8e56:c51e with SMTP id 586e51a60fabf-3c98e56caa3mr4670129fac.15.1760970354563; Mon, 20 Oct 2025 07:25:54 -0700 (PDT) MIME-Version: 1.0 References: <162e5330-861c-ecc7-45c1-aaa1aff26c88@appl-ecosys.com> <95de5a9b-4dd8-2f7-6e12-98c3d72c52@appl-ecosys.com> <712b8b5c-15d2-e284-a0c0-6263415250c3@appl-ecosys.com> In-Reply-To: <712b8b5c-15d2-e284-a0c0-6263415250c3@appl-ecosys.com> From: Ron Johnson Date: Mon, 20 Oct 2025 10:25:43 -0400 X-Gm-Features: AS18NWCpEBi4sDKtmLRoYVQCg96cCKIdDgEiChCyKuXWtpa51AlXn5DF-sDb05k Message-ID: Subject: Re: Arrays vs separate tables To: "pgsql-generallists.postgresql.org" Content-Type: multipart/alternative; boundary="000000000000719e8d064197dc06" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000719e8d064197dc06 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Mon, Oct 20, 2025 at 10:07=E2=80=AFAM Rich Shepard wrote: > On Mon, 20 Oct 2025, Micha=C5=82 K=C5=82eczek wrote: > > > There is also another concern - do you want to make sure phone numbers > are > > not shared? > > Michal, > > Shared with whom? I run a solo professional services consultancy so there= 's > only me here the database. > Multiple contacts at the same client company. If, for whatever reason, the phone number changes you've got to update X rows in your contacts table, whereas only one row needs to be updated when the schema meets 1NF. This eliminates update anomalies. --=20 Death to , and butter sauce. Don't boil me, I'm still alive. lobster! --000000000000719e8d064197dc06 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Mon, Oct 20, 2025 at 10:07=E2=80=AFAM = Rich Shepard <rshepard@appl-= ecosys.com> wrote:
On Mon, 20 Oct 2025,= Micha=C5=82 K=C5=82eczek wrote:

> There is also another concern - do you want to make sure phone numbers= are
> not shared?

Michal,

Shared with whom? I run a solo professional services consultancy so there&#= 39;s
only me here the database.

=
Multiple contacts at the same client company.=C2=A0 If, for whatever r= eason, the phone number changes you've got to update X rows in your con= tacts table, whereas only one row needs to be updated when the schema meets= 1NF.=C2=A0 This eliminates update anomalies.

--
Death to <Redacted>, and butter sauce.Don't boil me, I'm still alive.
<Redacted> lo= bster!
--000000000000719e8d064197dc06--