On Tuesday, June 25, 2024, James Coleman <jtc...@gmail.com> wrote: > Hello, > > It's possible I'm the only one who's been in this situation, but I've > multiple times found myself explaining to a user how column DEFAULT > expressions work: namely how the quoting on an expression following > the keyword DEFAULT controls whether or not the expression is > evaluated at the time of the DDL statement or at the time of an > insertion. >
I don’t know if it’s worth documenting but the following sentence is implied by the syntax: “Do not single quote the expression as a whole. Write the expression as you would in a select query.” David J.
