Re: null values in non-nullable column - Mailing list pgsql-sql

On Dec 5, 2006, at 12:49 , Tom Lane wrote:

> Actually I think this is a bug in the SQL spec :-(  The description of
> <joined table> says that output columns are "possibly nullable" if
> they're on the nullable side of the outer join, but it's not apparent
> that that idea is meant to negate a domain constraint.  And yet, if it
> does not, then an outer join with a NOT NULL domain column on the
> nullable side is just invalid.

Very interesting. Thanks for the explanation. I should dig into the  
spec more.

Michael Glaesemann
grzm seespotcode net