Re: Two academic questions - Mailing list pgsql-general

From Дмитрий Иванов
Subject Re: Two academic questions
Date
Msg-id CAPL5KHoWv7Q2HJEO55gY4C4PTu18Y5c7Z9tJ=KkFEyR_vs9VtA@mail.gmail.com
Whole thread Raw
In response to Re: Two academic questions  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
Thank you, I learned everything I needed to know.
--
Regards, Dmitry!


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


On Tuesday, February 1, 2022, Дмитрий Иванов <firstdismay@gmail.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.

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Two academic questions
Next
From: Karsten Hilbert
Date:
Subject: Re: Counting the number of repeated phrases in a column