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

From Rich Shepard
Subject Re: Arrays vs separate tables
Date
Msg-id 95de5a9b-4dd8-2f7-6e12-98c3d72c52@appl-ecosys.com
Whole thread Raw
In response to Re: Arrays vs separate tables  ("Peter J. Holzer" <hjp-pgsql@hjp.at>)
Responses Re: Arrays vs separate tables
List 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



pgsql-general by date:

Previous
From: Rob Sargent
Date:
Subject: Re: Convert date and time colums to datetime
Next
From: Rich Shepard
Date:
Subject: Re: Convert date and time colums to datetime