| 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: | Whole Thread | Raw Message | 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 |