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