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-20T14:50:01Z
Lists: pgsql-general

> On 20 Oct 2025, at 16:26, Rich Shepard <rshepard@appl-ecosys.com> wrote:
> 
> On Mon, 20 Oct 2025, Michał Kłeczek wrote:
> 
>> How do you make sure a phone number is not shared by two (or more)
>> customers?
> 
> Michal,
> 
> If it's the company's main telephone number then it's shared by all
> employees with phones on their desks. If it's a direct number then it
> connects to only a single phone.
> 
> Either way it doesn't matter to me. When the person I call is at their desk
> my call will either be transferred by the receptionist or directly ring their
> phone.
> 

Do you have any means to make sure you didn’t enter the same number for two different companies then?

—
Michal