Re: Entering '<1' and 'BDL' -- RESOLVED

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

In response to

Browse pdxpug by date

  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