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!
>
>
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 |