Re: 4 the FAQ: Are Commercial DBMS Truly Relational?
From: Paul <paul_at_test.com>
Date: Sun, 10 Oct 2004 11:14:50 +0100
Message-ID: <41690b98$0$44882$ed2619ec_at_ptn-nntp-reader02.plus.net>
Date: Sun, 10 Oct 2004 11:14:50 +0100
Message-ID: <41690b98$0$44882$ed2619ec_at_ptn-nntp-reader02.plus.net>
Laconic2 wrote:
>>You lost me. Do you mean something besides the part where
>>there are no rows on the right corresponding to rows on the
>>left, or do you mean something else?
> > No. I meant that an outer join can introduce NULLS, and NULLS don't belong > in relations.
In a truly relational system you'd have an equivalent to the SQL OUTER JOIN, but it would have to specify default values for every relevant column in the SELECT list, so that if there wasn't a matching row, you'd have some non-NULL values to return.
Paul. Received on Sun Oct 10 2004 - 12:14:50 CEST