Re: Two academic questions

From: Дмитрий Иванов <firstdismay(at)gmail(dot)com>
To: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Two academic questions
Date: 2022-02-02 06:12:51
Message-ID: CAPL5KHruMC7gxG_LDF6hSu6WU0+WLymVZg1Wj6sUYTUjxDWOgw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>
>
>>
>> DEFAULT VALUE <> GENERATED ALWAYS AS STORED
>> the DEFAULT value is not recalculated when the reference column are
>> changed. is not an identical construction GENERATED ALWAYS AS STORED
>>
>> *reply:*
>> They are in a separate list “Methods”.
>> This approach was used for other databases *long before* generated
>> columns were implemented in PostgreSQL.
>> ====================
>>
>>
> It has to do with the syntax of generated and that you can generate data
> in different ways. Calling those ways “methods” seems reasonable.
>
> It's hard to argue with that. However, it is not quite clear to me, what
origin are we talking about? I have worked with MS products and currently
with PostgreSQL and have not encountered this interpretation.

>
> The Shema-data thing is called the Boogyman pattern because teachers use
> it to scare students and illustrate what not to do when designing a data
> model. You can also find it abbreviated “EAV anti-pattern” where EAV
> stands for entity-attribute-value.
>

I think that's what I need, thank you.

> --
> Regards, Dmitry!
>
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message David G. Johnston 2022-02-02 06:36:49 Re: Two academic questions
Previous Message David G. Johnston 2022-02-02 05:19:52 Re: Two academic questions