From: | "Melissa Hollingsworth" <melissa(at)fastanimals(dot)com> |
---|---|
To: | pdxpug(at)postgresql(dot)org |
Subject: | Re: Entering '<1' and 'BDL' -- RESOLVED |
Date: | 2010-04-20 16:16:02 |
Message-ID: | op.vbg0w0emoen9tq@satin.mshome.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pdxpug |
On Mon, 19 Apr 2010 20:09:08 -0600, Rich Shepard
<rshepard(at)appl-ecosys(dot)com> wrote:
> On Mon, 19 Apr 2010, Rich Shepard wrote:
>
>> Any thoughts?
>
> NULL does the trick. After all, if the value is below detection
> limits or
> less than 1 the actual value is unknown.
Might you ever need to distinguish between something less than one
and something which was actually undetectably low? I don't like
losing information, personally.
Using NULL for both loses the distinction between them. If you'll
never need to distinguish them, why are there two valid NAN values
in the first place?
--
Melissa Hollingsworth
melissa(at)fastanimals(dot)com
+1 503 841 5240
From | Date | Subject | |
---|---|---|---|
Next Message | Ewan, Michael | 2010-04-20 17:38:10 | Re: Entering '<1' and 'BDL' |
Previous Message | Rich Shepard | 2010-04-20 02:09:08 | Re: Entering '<1' and 'BDL' -- RESOLVED |