Re: Does Codd's view of a relational database differ from that ofDate& Darwin? [M.Gittens]

From: Gene Wirchenko <genew_at_ucantrade.com.NOTHERE>
Date: Tue, 07 Jun 2005 16:17:38 -0700
Message-ID: <ejaca1ps9ccuho7ckk1ul5i7kb0lpu0p85@4ax.com>

On 6 Jun 2005 11:32:00 -0700, "Mikito Harakiri" <mikharakiri_nospaum_at_yahoo.com> wrote:

[snip]

>Hear, hear! It totally escapes me how could somebody invent putting
>nonumeric value ("not salaried") into numeric column. For all reporting
>purposes unknown salary is salary equal to 0. If you want to run a

Give me a report of the number of people for whom we do not know their salary. If you have 0 meaning an unknown salary, and since 0 can also mean a salary of 0, you can not determine the count.

>report of all salaries that are wrong (and, therefore, are subject to
>adjustment) then, having a flag "salary entry is incorrect" is not
>going to help. An entry clerk that misses a digit in the salary is not
>going to mark it with such a flag anyway:-)

Sincerely,

Gene Wirchenko Received on Tue Jun 07 2005 - 18:17:38 CDT