Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: Does Codd's view of a relational database differ from that ofDate& Darwin? [M.Gittens]

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@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 Tue Jun 07 2005 - 19:27:07 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US