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

From Michał Kłeczek
Subject Re: Arrays vs separate tables
Date
Msg-id 5D3A03DC-02F1-4DD9-8C5C-C6F5F484E4A3@kleczek.org
Whole thread Raw
In response to Re: Arrays vs separate tables  (Rich Shepard <rshepard@appl-ecosys.com>)
List 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


pgsql-general by date:

Previous
From: Rich Shepard
Date:
Subject: Re: Arrays vs separate tables
Next
From: Paul Austin
Date:
Subject: Extend CREATE POLICY to add IF EXISTS