Re: Does Codd's view of a relational database differ from that ofDate& Darwin? [M.Gittens]
From: paul c <toledobythesea_at_oohay.ac>
Date: Wed, 08 Jun 2005 00:27:07 GMT
Message-ID: <vXqpe.1593685$8l.691371_at_pd7tw1no>
>
>
> 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.
>
> ...
Date: Wed, 08 Jun 2005 00:27:07 GMT
Message-ID: <vXqpe.1593685$8l.691371_at_pd7tw1no>
Gene Wirchenko wrote:
> 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.
>
> ...
just wait until the next payday and count the number of people who squawk. if nobody complains, drop the salary attribute from whatever table you are looking at since it is clearly redundant (and wrong).
p Received on Wed Jun 08 2005 - 02:27:07 CEST