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 1uokz0-009eDG-BU for pgsql-general@arkaria.postgresql.org; Wed, 20 Aug 2025 15:44:15 +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 1uokyz-009K8G-OX for pgsql-general@arkaria.postgresql.org; Wed, 20 Aug 2025 15:44:14 +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 1uokyz-009K88-DV for pgsql-general@lists.postgresql.org; Wed, 20 Aug 2025 15:44:14 +0000 Received: from mail-oo1-xc35.google.com ([2607:f8b0:4864:20::c35]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1uokyx-000vqz-2Y for pgsql-general@lists.postgresql.org; Wed, 20 Aug 2025 15:44:13 +0000 Received: by mail-oo1-xc35.google.com with SMTP id 006d021491bc7-61d9db7d701so2624eaf.1 for ; Wed, 20 Aug 2025 08:44:11 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1755704649; x=1756309449; darn=lists.postgresql.org; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :from:to:cc:subject:date:message-id:reply-to; bh=MJ/9Gq8LmN9IhavEfM/veYXb9XQyww1Q5EoPNUFWkJI=; b=OMn0YVxHZiYiis3c0c6Xu0y4WlQm6LlfMhQzCTwg189rR2WnUBJkUbv4y3ECGczlrJ lfKVVImCIz8BDQHzt60xJL+6oNHpT69+EmT7tIdD2D3Z85sb7Vd76cTvSmOkR7lAEUkT 8z1Gm6AFUwxUOjjrl9SI0CyHV1NMqHoGoNf2+MMbrOr2vyapPK3H6oklvfhy2YBZSeG/ 9lbspWZmKIQkgYQ8vCqNJnbsYH8Vv2TIKTxU4R4Tk4mV29yThUuaYF5pHLXPKd8SBH5d 9uwHCiWkZPgC7gd5Rfh/E0BEXEgkuLBTz+teoOHoaU/aQPQldHVEbxZkZrT8pfPWoB8V j+jA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1755704649; x=1756309449; h=to:subject:message-id:date:from:in-reply-to:references:mime-version :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=MJ/9Gq8LmN9IhavEfM/veYXb9XQyww1Q5EoPNUFWkJI=; b=ZSWqTDMZROVHSlzQndfep+9pqiYDPo4syQ2WAfAYPQuiMb71kEC6/INsWSccmn6ndA PJ24Dng6j1sVMRNX0CqD7k1wbRN9y/0sg7mm4b9UivwM4EEk5tqb50xdTWctFAV+b1YV OyMcLKm+xByHenRBj1X/g0+GGzTLYek9WCQdh/o9nOOvM6VyRD82tLEPnIOuPDenV4KM tQdZlYXz6uQXbJz8a0FK7DkuhTKTiHE0IgkIo+WSw20vnz5oQBhTE5D9lhlatf+xbnuf oojGsE1CYTycdr8hKAW7fHVehE5UL2PVQmj5llA9/wPGv3si0lgeCdXYXCEl9EmFeoOq mAcw== X-Gm-Message-State: AOJu0YyqDJLrixQlf6mHoK5ino/Nm3bY2NWnNxRKJvlsF9p/0HBOCwqP /N+9KEHxAxQHHp++yjF6CadozHGxusTXsHKR2qIe9x0P9TJvc3qninzeNmSW2ghs1RO4Vf3DoMC dGRj/77lsiyMJUvbbP1C3Wy8v7FFY88UIUg== X-Gm-Gg: ASbGnct/cesn+eWsEcGBIt15BDD8ZILPAVrGdHs3663v3N2jnPG1iWby/HVYb5Bzb3U y2T63U2/grc8PBsVBSYCMAaUPZWTKf1eDWXWuPUEkdaqZe2+A/FMNLShdsYQs2HXnCUhOCJFKUu JJJA1QHXBKivxT/MpqOJ0EwasixQ9A+J7iK4yR6IcYP8aPrckOklrIYJRZS/Ddr/GP1wXnsgpDB a6f4I5d X-Google-Smtp-Source: AGHT+IEO5JBybOcwCix9j/4Xf26YDyG/sMWvJZsrlVlOJX/sraKADGayNgWPHPaAhJPQjVpfQu4IdRIvO2U0TKd/nt4= X-Received: by 2002:a05:6808:218f:b0:433:f8ac:2ec0 with SMTP id 5614622812f47-437720dd51cmr1599526b6e.29.1755704648802; Wed, 20 Aug 2025 08:44:08 -0700 (PDT) MIME-Version: 1.0 References: <7cdd7a73-5a61-451b-9556-5cb523cfb239@aklaver.com> In-Reply-To: <7cdd7a73-5a61-451b-9556-5cb523cfb239@aklaver.com> From: Ron Johnson Date: Wed, 20 Aug 2025 11:43:57 -0400 X-Gm-Features: Ac12FXw54lgD0Hc69jn6yqLhbNtRRYv88gwIdIY9SJn2oOcotZ-opzV5nVLS3dY Message-ID: Subject: Re: Domains vs data types To: "pgsql-generallists.postgresql.org" Content-Type: multipart/alternative; boundary="000000000000ec270c063ccdd73c" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000ec270c063ccdd73c Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Wed, Aug 20, 2025 at 11:05=E2=80=AFAM Adrian Klaver wrote: [snip] > > Personally I don't see that integer --> aint really helps. > No one's going to create the domain "aint", but a DB designer in a rigorous environment _will_ create multiple, meaningfully-named domains, all of which happen to be INTEGER. Makes large-team developing easier. The alternative is Really Really Long column names, and consistent use of agreed-upon suffixes. --=20 Death to , and butter sauce. Don't boil me, I'm still alive. lobster! --000000000000ec270c063ccdd73c Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Wed, Aug 20, 2025 at 11:05=E2=80=AFAM = Adrian Klaver <adrian.klave= r@aklaver.com> wrote:
[snip]=C2=A0

Personally I don't see that integer --> aint really helps.
=C2=A0
No one's going to create the domain = "aint", but a DB designer in a rigorous environment _will_ create= multiple, meaningfully-named domains, all of which happen to be INTEGER.= =C2=A0 Makes large-team developing=C2=A0easier.

Th= e alternative is Really Really Long column names, and consistent use of agr= eed-upon suffixes.

--
Death to <Redacted>, and butter sauce.
Don't boil me, I'= ;m still alive.
<Redacted> lobster!
--000000000000ec270c063ccdd73c--