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 07:12:24
Message-ID: CAPL5KHoWv7Q2HJEO55gY4C4PTu18Y5c7Z9tJ=KkFEyR_vs9VtA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Thank you, I learned everything I needed to know.
--
Regards, Dmitry!

ср, 2 февр. 2022 г. в 11:36, David G. Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>:

>
>
> On Tuesday, February 1, 2022, Дмитрий Иванов <firstdismay(at)gmail(dot)com>
> wrote:
>
>>
>>>>
>>>> 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.
>>
>
> “Origin”? The documentation, and my internalizing of it based on my
> personal experiences.
>
> Anyway, I did my best given the unclear (to me at least) and limited
> information you provided, and the fact I don’t really understand the
> question.
>
> David J.
>
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Karsten Hilbert 2022-02-02 07:56:10 Re: Counting the number of repeated phrases in a column
Previous Message David G. Johnston 2022-02-02 06:36:49 Re: Two academic questions