Re: Arrays vs separate tables

Поиск
Список
Период
Сортировка
От Ron Johnson
Тема Re: Arrays vs separate tables
Дата
Msg-id CANzqJaC8JrirUM7Duu9Pp4vdLU85GdqSv6BcduamquFYz13kMg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Arrays vs separate tables  (Rich Shepard <rshepard@appl-ecosys.com>)
Список 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 по дате отправления: