Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1vArDS-006dYe-Cj for pgsql-general@arkaria.postgresql.org; Mon, 20 Oct 2025 14:50:29 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1vArDR-001gSw-7I for pgsql-general@arkaria.postgresql.org; Mon, 20 Oct 2025 14:50:28 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1vArDQ-001gSa-RZ for pgsql-general@lists.postgresql.org; Mon, 20 Oct 2025 14:50:27 +0000 Received: from mail-ej1-x62e.google.com ([2a00:1450:4864:20::62e]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vArDN-003FVX-2S for pgsql-general@lists.postgresql.org; Mon, 20 Oct 2025 14:50:27 +0000 Received: by mail-ej1-x62e.google.com with SMTP id a640c23a62f3a-b4736e043f9so747139666b.0 for ; Mon, 20 Oct 2025 07:50:25 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=kleczek.org; s=google; t=1760971823; x=1761576623; darn=lists.postgresql.org; h=to:in-reply-to:cc:references:message-id:date:subject:mime-version :from:content-transfer-encoding:from:to:cc:subject:date:message-id :reply-to; bh=utKbVtmUIRvkmJ4IgHSOMiKIHlyCIfqfJo73Kzkov68=; b=UjfcRiGigztzlBMqEnorUBFFgC4Q6YwonLiGr5y3eEl0yQ0m2s3XJdh2TTcAKapdxx CaQKX8Ac7GOFT4WP4qXXJDCv2d4fSud1Guy5qGNcOsMQ5S3Kr0lcRdz14bLVJgumwr0/ sOiOxwUParfB7fQJpcJudP7GCcCibyQucqMl8= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1760971823; x=1761576623; h=to:in-reply-to:cc:references:message-id:date:subject:mime-version :from:content-transfer-encoding:x-gm-message-state:from:to:cc :subject:date:message-id:reply-to; bh=utKbVtmUIRvkmJ4IgHSOMiKIHlyCIfqfJo73Kzkov68=; b=a25Dxgx7qyylVo8pBOQ0M1/2bNrv+/EqGEo31OssEdyyu/gJmnDKDmGxhaDxmgE3ap r1ix4N1R14k+Gbm756RavrFNmHWkQinV7pts2+cKFucnsua/WuI44ExKMCjJ8GolCRxv eU6YBCSZ7cpwHe/TQFiNFRktOpQ0CIcDiPsBnBJs3T+arDCMJ4em51uy6nLdRezV5Qrx rQd9KsAarh0Q64qqBH5DbfNJ2SWRFGiaXRLNGQdWsuFsGusNoIp6ytXJ4WTnldK4jONk fK5z8z4NeSfpUyThgtY7/RqjDE3LvnihISTPzYFd3tTrAhSUQwRsyXOyUjNUY7gYbyM2 u25g== X-Gm-Message-State: AOJu0YyLITz10hfprOtokB/DruGydFbQlRaKWohTyV6JQ1d41Tzhm8D2 41ml+eut3DISNTCYO1stkzBskgSjzURYIUYZ+3Vyjt73VIulz+22yGTGPZuozVARvClnFhbQFst LiOmj X-Gm-Gg: ASbGncvVXlEKtEUPGcBtzf1sFO2Vn/5AbWThwRNTEEd0lKb5EHzf0myDeJavm2GOMXS upbWshQR1ZAoWXMG0hCZHPHGRRJ0jLfmluwSFfkfZqZ9t5V514sIgsqS/oBUjftL5LorSwgKVA0 zbUt96jXqhU+YzggyZBPGXZXky6HNqHxWYi0j5gS0FQX2cyEmtWB+91WTn50SXorPmwcaILRkCJ dQQ/ZtOAVAJJSEAi19kNEF1hM8E3sONgpMF66CSzsiA8MVdyTL33eS8xj7vpwlMQFJ4Om+BtvKh +7dnZqPZZIQpSzS6W/MXlK4Vbp4HRMNiD8xc+T6rS0rUo0l4Lq+eA2xjdJiQsmSzxTeWJ7Pdqb6 AxMejiVcdXZHAOkQ2sqjfCgKHoYvwPsli15LsDH9acoBw4h1wzrHVc9WOmzinXRgZ4vmAuBE8pn w/ArBkUJEKRvxUwXDjb8CRDZiG6MM0nO2pwiWROw== X-Google-Smtp-Source: AGHT+IFnHWfTw16/HgaijVmkukOIMGyzA9Blfy+QEGq+4HPx1MFlOJ03YF3r53fBI7QamZy2rqZv4Q== X-Received: by 2002:a17:907:bb49:b0:b04:9ad9:5b29 with SMTP id a640c23a62f3a-b6474241271mr1695265066b.54.1760971822455; Mon, 20 Oct 2025 07:50:22 -0700 (PDT) Received: from smtpclient.apple (b15.kleczek.org. [185.20.172.182]) by smtp.gmail.com with ESMTPSA id a640c23a62f3a-b65e7da33dcsm814632666b.12.2025.10.20.07.50.21 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Mon, 20 Oct 2025 07:50:21 -0700 (PDT) Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable From: =?utf-8?Q?Micha=C5=82_K=C5=82eczek?= Mime-Version: 1.0 (1.0) Subject: Re: Arrays vs separate tables Date: Mon, 20 Oct 2025 16:50:01 +0200 Message-Id: <920897C5-295A-40CA-8AE7-11581ECB169A@kleczek.org> References: <9555eb-681c-3d89-4af4-b0c68d476db2@appl-ecosys.com> Cc: pgsql-general@lists.postgresql.org In-Reply-To: <9555eb-681c-3d89-4af4-b0c68d476db2@appl-ecosys.com> To: Rich Shepard X-Mailer: iPhone Mail (22G100) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > On 20 Oct 2025, at 16:26, Rich Shepard wrote: >=20 > =EF=BB=BFOn Mon, 20 Oct 2025, Micha=C5=82 K=C5=82eczek wrote: >=20 >> How do you make sure a phone number is not shared by two (or more) >> customers? >=20 > Michal, >=20 > 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. >=20 > Either way it doesn't matter to me. When the person I call is at their des= k > my call will either be transferred by the receptionist or directly ring th= eir > phone. >=20 Do you have any means to make sure you didn=E2=80=99t enter the same number f= or two different companies then? =E2=80=94 Michal=20=