Re: [HACKERS] generated columns
| От | Serge Rielau |
|---|---|
| Тема | Re: [HACKERS] generated columns |
| Дата | |
| Msg-id | BFDFB10B-27E1-4427-B304-EEDC47578327@rielau.com обсуждение исходный текст |
| Ответ на | Re: [HACKERS] generated columns (Jaime Casanova <jaime.casanova@2ndquadrant.com>) |
| Список | pgsql-hackers |
Why is a NULL reasonable for before triggers?On Sep 12, 2017, at 12:35 PM, Jaime Casanova <jaime.casanova@2ndquadrant.com> wrote:
also is interesting that in triggers, both before and after, the
column has a null. that seems reasonable in a before trigger but not
in an after trigger
If I create a table with a column with default and I omit that column on INSERT
Is the column value also NULL in the before trigger? (I hope not)
BTW, the original idea behind generated columns was to materialize them.
Reason being to avoid expensive computations of frequently used expressions
(and to support indexing in the absence of indexes with expressions)
You may find the following amusing:
Cheers
Serge Rielau
В списке pgsql-hackers по дате отправления: