Nikhil Sontakke <nikhil(dot)sontakke(at)enterprisedb(dot)com> writes:
> I think the semantics should be pretty ok as is. But I saw another DB
> honoring the NOT NULL modifiers and hence the wonder if there is
> something about this in the standards.
Actually, SQL:2008 does say that if an output column of the SELECT is
known not nullable, then the created table should have the NOT NULL
property for that column. We don't implement anything about "known not
nullable", though, so I'd view this as a small part of an unimplemented
SQL feature. The usefulness seems rather debatable anyway.
regards, tom lane