Why does PostgreSQL allow NULLs in domains that prohibit NULL?

11 votes

1 answer

1586 views

                          PostgreSQL allows NULLs in domains marked as NOT NULL. Why is this, the docs  say this about it,

> It is possible for a column that is nominally of the domain type to read as null despite there being such a constraint. For example, this can happen in an outer-join query, if the domain column is on the nullable side of the outer join. 

Can this be better explained?

Asked by Evan Carroll (65502 rep)

May 11, 2021, 04:59 PM
Last activity: May 11, 2021, 11:26 PM

Why does PostgreSQL allow NULLs in domains that prohibit NULL?

Related Questions