Re: Arrays vs separate tables

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Arrays vs separate tables
Date: 2025-10-20 12:55:33
Message-ID: 95de5a9b-4dd8-2f7-6e12-98c3d72c52@appl-ecosys.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, 20 Oct 2025, Peter J. Holzer wrote:

> * Simplicity: If a set of values is always fetched together and updated
> together, you might as well treat it as a unit and not split it over
> multiple tables

> The second may be relevant for you. If you always display and edit the
> phone numbers of a contact together and your frontend makes it easier to
> edit an array than a subset of rows from a table, you might just stuff
> them into a table and ignore "purity".

Peter,

Thank you. That's my use case.

Regards,

Rich

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rich Shepard 2025-10-20 12:58:16 Re: Convert date and time colums to datetime
Previous Message Rob Sargent 2025-10-20 12:53:08 Re: Convert date and time colums to datetime