Re: Arrays vs separate tables

Michał Kłeczek <michal@kleczek.org>

From: Michał Kłeczek <michal@kleczek.org>

To: Rich Shepard <rshepard@appl-ecosys.com>

Cc: pgsql-general@lists.postgresql.org

Date: 2025-10-20T15:41:54Z

Lists: pgsql-general

> On 20 Oct 2025, at 17:06, Rich Shepard <rshepard@appl-ecosys.com> wrote:
> 
> On Mon, 20 Oct 2025, Michał Kłeczek wrote:
> 
>> Do you have any means to make sure you didn’t enter the same number for
>> two different companies then?
> 
> Michal,
> 
> Yes. New companies are added one-at-a-time. In the 28 years I've used
> postgres I've not had any such issues.

Ok, if manual integrity validation works for you then arrays are fine.


—
Michal