Re: Does Codd's view of a relational database differ from that ofDate& Darwin? [M.Gittens]
Date: Tue, 07 Jun 2005 16:17:38 -0700
Message-ID: <ejaca1ps9ccuho7ckk1ul5i7kb0lpu0p85_at_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 Wed Jun 08 2005 - 01:17:38 CEST