Re: Domains vs data types

From: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
To: "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Domains vs data types
Date: 2025-08-20 15:43:57
Message-ID: CANzqJaAK0k8A=FzL4gNmyKoHVbpA5LQVL8+=veaYBXd+i9mw8Q@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Aug 20, 2025 at 11:05 AM Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
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.

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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message hubert depesz lubaczewski 2025-08-20 16:08:11 Re: Streaming replica hangs periodically for ~ 1 second - how to diagnose/debug
Previous Message Adrian Klaver 2025-08-20 15:14:47 Re: Streaming replica hangs periodically for ~ 1 second - how to diagnose/debug