public inbox for [email protected]  

help / color / mirror / Atom feed

From: Ron Johnson <[email protected]>
To: pgsql-generallists.postgresql.org <[email protected]>
Subject: Re: Arrays vs separate tables
Date: Mon, 20 Oct 2025 10:25:43 -0400
Message-ID: <CANzqJaC8JrirUM7Duu9Pp4vdLU85GdqSv6BcduamquFYz13kMg@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>
	<pyh2kcisxwrhzz255gaiaawo5yubirdifzsfvz3okqcjeaaqqr@6lq5n6idswg7>
	<[email protected]>
	<[email protected]>
	<[email protected]>

On Mon, Oct 20, 2025 at 10:07 AM Rich Shepard <[email protected]>
wrote:

> On Mon, 20 Oct 2025, Michał Kłeczek 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.

-- 
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!

view thread (8+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: Arrays vs separate tables
  In-Reply-To: <CANzqJaC8JrirUM7Duu9Pp4vdLU85GdqSv6BcduamquFYz13kMg@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox