Serge Rielau <se...@rielau.com> writes: >> On Oct 6, 2016, at 5:25 AM, Vitaly Burovoy <vitaly.buro...@gmail.com> wrote: >>> Which makes me think we should call this missing_value or absent_value >>> so its clear that it is not a "default" it is the value we use for >>> rows that do not have any value stored for them.
> I like Tomâs âcreation defaultâ. Another one could be âinitial > defaultâ. > But that, too, can be misread. Something based on missing_value/absent_value could work for me too. If we name it something involving "default", that definitely increases the possibility for confusion with the regular user-settable default. Also worth thinking about here is that the regular default expression affects what will be put into future inserted rows, whereas this thing affects the interpretation of past rows. So it's really quite a different animal. That's kind of leading me away from calling it creation_default. BTW, it also occurs to me that there are going to be good implementation reasons for restricting it to be a hard constant, not any sort of expression. We are likely to need to be able to insert the value in low-level code where general expression evaluation is impractical. regards, tom lane -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers