Re: Arrays vs separate tables - Mailing list pgsql-general

From Ron Johnson
Subject Re: Arrays vs separate tables
Date
Msg-id CANzqJaC8JrirUM7Duu9Pp4vdLU85GdqSv6BcduamquFYz13kMg@mail.gmail.com
Whole thread Raw
In response to Re: Arrays vs separate tables  (Rich Shepard <rshepard@appl-ecosys.com>)
List pgsql-general
On Mon, Oct 20, 2025 at 10:07 AM Rich Shepard <rshepard@appl-ecosys.com> 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!

pgsql-general by date:

Previous
From: Michał Kłeczek
Date:
Subject: Re: Arrays vs separate tables
Next
From: Rich Shepard
Date:
Subject: Re: Arrays vs separate tables