Re: Guideline to save 0 or NULL to a NUMBER column

No, not I, but I know where to look for it

http://goldennumber.net/ and
http://www.cise.ufl.edu/~sahni/dsaaj/enrich/c11/function.htm

"Brian Peasland" <oracle_dba_at_remove_spam.peasland.com> wrote in message news:3EEF2897.63ED03AA_at_remove_spam.peasland.com...
> Would you save 3 when you meant pi? Would you save 5 when you meant 12?
> Would you save 1.6180339887 or -0.6180339887 (anyone know what those two
> numbers are?) when you meant 1234567890? I wouldn't. I'd save what I
> meant to save. If I mean 5, then save 5. If I mean 3, then I'd save 3.
> If I didn't know what I meant, then I'd save NULL.
>
> Just my 3.14159265 cents worth,
> Brian
>
> Andrew wrote:
> >
> > Is that any guideline to either save 0(zero)or NULL to a NUMBER
> > column? I personal prefer saving NULL to database to save space on a
> > large table. Some people seem prefer saving 0. Is this just a personal
> > choice or there is some guideline we better follow. Thanks.
>
> --
> ===================================================================
>
> Brian Peasland
> oracle_dba_at_remove_spam.peasland.com
>
> Remove the "remove_spam." from the email address to email me.
>
>
> "I can give it to you cheap, quick, and good. Now pick two out of
> the three"
Received on Tue Jun 17 2003 - 10:59:53 CDT